ORACLE





1. Three beauty
pageant finalists-Cindy, Amy and Linda-The winner was musician. The one
who was not last or first was a math major. The one who came in third had
black hair. Linda had red hair. Amy had no musical abilities. Who was
first?
          
(A) Cindy                      
(B) Amy                      
(C) Linda                      
(D) None of these

2. Two twins have certain peculiar
characteristics. One of them always lies on Monday, Wednesday, Friday. The
other always lies on Tuesdays, Thursday and Saturdays. On the other days
they tell the truth. You are given a conversation.

                     
Person A- today is Sunday, my name is
Anil
                     
Person B-today is Tuesday, my name is
Bill                   
    What day is today?

          
(A) Sunday                      
(B) Tuesday                      
(C) Monday                  
(D) Thursday

3. The difference of a number and its reciprocal
is 1/2.The sum of their squares is 

          
(A) 9/4                          
(B) 4/5                          
(C) 5/3                          
(D) 7/4

4. The difference of a number and its square is
870.What is the number?

          
(A) 42                          
(B) 29                              
(C) 30                          
(D) 32

5. A trader has 100 Kg of wheat, part of which he sells
at 5% profit and the rest at 20% profit. He gains 15% on the whole. Find
how much is sold at 5% profit?

          
(A) 60                          
(B) 50                              
(C) 66.66                          
(D) 33.3

6. Which of the following points are collinear?

          
(A) (3,5)   (4,6)   (2,7)                              
(B) (3,5)   (4,7)   (2,3)
          
(C) (4,5)   (4,6)   (2,7)                              
(D) (6,7)   (7,8)   (2,7)

7. A
man leaves office daily at 7pm.a driver with car comes from his home to
pick him from office and bring back home. One day he gets free at 5.30 and
instead of waiting for driver he starts walking towards home. In the way
he meets the car and returns home on car. He reaches home 20 minutes
earlier than usual. In how much time does the man reach home usually?

          
(A) 1 hr 20
min                          
(B) 1
hr                      
(C) 1 hr 10
min                   
(D) 55 min

8. If m:n = 2:3,the value of 3m+5n/6m-n is

          
(A) 7/3                          
(B) 3/7                          
(C) 5/3                          
(D) 3/5

9. A dog taken four leaps for every five leaps of hare
but three leaps of the dog is equal to four leaps of the hare. Compare
speed?
          
(A) 12:16                      
(B) 19:20                      
(C) 16:15                      
(D) 10:12

10. A watch ticks 90 times in 95 seconds. And
another watch ticks 315 times in 323 secs. If they start together, how
many times will they tick together in first hour?

          
(A) 100
times                  
(B) 101
times                  
(C) 99
times                  
(D) 102 times

11. The purpose of defining an index is 

          
(A) Enhance Sorting
Performance                   
   (B) Enhance Searching
Performance
          
(C) Achieve
Normalization                              
  (D) All of the above

12. A transaction does not
necessarily need to be

          
(A) Consistent              
(B) Repeatable              
(C) Atomic              
(D) Isolated

13. To group users based on common access
permission one should use 

          
(A) User
Groups              
(B) Roles              
(C) Grants              
(D) None of the above

14. PL/SQL uses which of the following

          
(A) No
Binding          
(B) Early
Binding          
(C) Late
Binding          
(D) Deferred Binding

15. Which of the constraint can be
defined at the table level as well as at the column level

          
(A) Unique                  
(B) Not
Null                  
(C) Check                  
(D) All the above

16. To change the default date format in a
SQLPLUS Session you have to 

          
(A) Set the new format in the DATE_FORMAT key in the windows
Registry.
          
(B) Alter session to set
NLS_DATE-FORMAT.
          
(C) Change the Config.ora File for the date
base.
          
(D) Change the User Profile USER-DATE-FORMAT.

17. Which of the
following is not necessarily an advantages of using a package rather than
independent stored procedure in data base. 

          
(A) Better
performance.                                                  
(B) Optimized memory
usage.
          
(C) Simplified Security
implementation.                            
(D) Encapsulation.

18. Integrity constrains are not checked at
the time of 

          
(A) DCL
Statements.                          
(B) DML
Statements.
          
(C) DDL
Statements.                          
(D) It is checked all the above cases.

19. Roll Back segment
is not used in case of a

          
(A) DCL Statements.       (B) DML
Statements.       (C) DDL
Statements.       (D) all of the
above.

20. An Arc relationship is applicable when

          
(A) One child table has multiple parent relation, but for anyone
instance of a child record only one of the relations is
applicable.
          
(B) One column of a table is related to another column of the same
table.
          
(C) A child table is dependent on columns other than the primary key
columns of the parent
table.
          
(D) None of the above.

21. What is true about the following C
functions?

          
(A) Need not return any
value.                          
(B) Should always return an
integer.
          
(C) Should always return a
float.                       
(D) Should always return more than one value.

22. enum number
{ a=-1, b=4, c,d,e,} what is the value of e?

          
(A) 7                               
(B) 4                              
(C) 5                              
(D) 3

23. Which of the following about automatic variables
within a function is correct?

          
(A) Its type must be declared before using the
variable.                  
(B) They are
local.
          
(C) They are not initialized to
zero.                                                
(D) They are global.

24. Consider the following program
segment

                                 
int n,
sum=5;
                                 
switch(n)
                                 
{
                                      case
2:sum=sum-2;
                                      case
3:sum*=5;
                                      break;
                                      default:sum=0;
                                 
}
    if n=2, what is the value of the sum?

          
(A) 0                          
(B) 15                          
(C) 3                          
(D) None of these.


25. Which of the following is not an
infinite
loop?                                                       
   
   (A) x=0;                                                                          
(B) # define TRUE
0.... 
         do{                                                                                   
While(TRUE){....}
               
/*x unaltered within the
loop*/                             
(C) for(;;)  
{....}
           
....}
         
While(x==0);                                                            
(D) While(1)
{....}                
 

26. Output of the following program is 

                               
main()
                               
{
                                   
int
i=0;
                                   
for(i=0;i<20;i++)
                                   
{
                                       
switch(i){
                                                       
case
0:
                                                           
i+=5;
                                                       
case
1:
                                                           
i+=2;
                                                       
case
5:
                                                           
i+=5;
                                                       
default:
                                                           
i+=4;
                                                       
break;
                                                   
}
                                   
}
                             

          
(A) 5,9,13,17                  
(B) 12,17,22                  
(C) 16,21                  
(D) syntax error.

27. What does the following function print?

                               
func(int
i)
                               
{
                                   
if(i%2) return
0;
                                   
else return
1;
                               
}
                               
main()
                               
{
                                   
int
i=3;
                                   
i=func(i);
                                   
i=func(i);
                                   
printf("%d",i);
                               

          
(A) 3                               
(B) 1                                  
(C) 0                              
(D) 2

28. What will be the result of the following
program?
                               
char*g()
                               
{
                                   
static char
x[1024];
                                   
return
x;
                               
}
                               
main()
                               
{
                                   
char*g1="First
String";
                                   
strcpy(g(),g1);
                                   
g1=g();
                                   
strcpy(g1,"Second
String");
                                   
printf("Answer is:%s",
g());
                               
}
          
(A) Answer is: First
String                       
   (B) Answer is: Second
String
          
(C) Run time Error/Core
Dump               
   (D) None of these

29. Consider the following
program

                               
main()
                               
{
                                   
int
a[5]={1,3,6,7,0};
                                   
int
*b;
                                   
b=&a[2];
                               
}
      The value of b[-1] is

          
(A) 1                              
(B) 3                              
(C) -6                              
(D) none

30. Given a piece of code

                               
int
x[10];
                               
int
*ab;
                               
ab=x;
      To access the 6th element of the
array which of the following is incorrect?

          
(A) *(x+5)                      
(B) x[5]                      
(C) ab[5]                      
(D) *(*ab+5}
.

0 comments:

Post a Comment