For Placement Papers & Interview Questions Of Other Companies, Register At [Link]

com

Oracle Exam Model Paper

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/[Link] 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 [Link] 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

For Jobs Anywhere In India, Register At [Link]

For Placement Papers & Interview Questions Of Other Companies, Register At [Link]
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 [Link] 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.

For Jobs Anywhere In India, Register At [Link]

For Placement Papers & Interview Questions Of Other Companies, Register At [Link]
(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;

For Jobs Anywhere In India, Register At [Link]

For Placement Papers & Interview Questions Of Other Companies, Register At [Link]
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;

For Jobs Anywhere In India, Register At [Link]

For Placement Papers & Interview Questions Of Other Companies, Register At [Link]
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} . This is the oracle paper held on July 13 2003 at NITK Surathkal. The test has 2 sections : 30 technical and 30 aptitude and 60 min time.

Technical section: its very easy any one can answer 25 qns without preperation. some are 1. how compiler treats variables of recursive functions 2. what is orthogonal matrix? 3. given two tables and asked 2 qns on those table , one is on join and another is on NOT IN 4. given some qns on pointers( pretty easy) 5. given five qns on data structures like , lifo, fifo 6. qtn on primary key 7. how NULL in sql is treated? 8. given a doubly linked list and asked r->left->right->data ans: r->data 9:explain const char *ptr and char *const ptr remaining i didn`t remember aptiude 15 quant apti from rs agrval 15 verbal apti, in this 4 are odd word out and 4 are sentese ordering when jumbled senteses given and 4 are reasoning Model Questions From the Exam conducted by Oracle Bangalore in 2002. 1. What is the output of the following program? #include<stdio.h> #include<math.h> void main( ) { int a=5,b=7; printf(%d\n,b\a); } A. 1.4 B. 1.0

For Jobs Anywhere In India, Register At [Link]

For Placement Papers & Interview Questions Of Other Companies, Register At [Link]

C. 1 D. 0 2. What is the output of the following program listing? #include<stdio.h> void main ( ) { int x,y: y=5; x=func(y++); printf(%s\n, (x==5)?true;false); } int func(int z) { if (z== 6) return 5; else return 6; } A True B false C either a or b D neither a nor b

3. What is the output of the following progarm?

For Jobs Anywhere In India, Register At [Link]

For Placement Papers & Interview Questions Of Other Companies, Register At [Link]

#include<stdio.h> main( ) { int x,y=10; x=4; y=fact(x); printf(%d\n,y); } unsigned int fact(int x) { return(x*fact(x-1)); } A. 24 B. 10 C. 4 D. none

4. Consider the following C program and chose collect answer #include<stdio.h> void main( ) { inta[10],k; for(k=0;k<10;k++) { a[k]=k; } printf (%d\n,k);

For Jobs Anywhere In India, Register At [Link]

For Placement Papers & Interview Questions Of Other Companies, Register At [Link]

} A. value of k is undefined ; unpredictable answer B. 10 C. program terminates with run time error D. 0 5. Consider the prog and select answer #include<stdio.h> void main ( ) { int k=4,j=0: switch (k) { case 3; j=300; case 4: j=400: case 5: j=500; } printf (%d\n,j); } A. 300 B. 400 C. 500 D. 0

For Jobs Anywhere In India, Register At [Link]

For Placement Papers & Interview Questions Of Other Companies, Register At [Link]
6. Consider the following statements: Statement 1 A union is an object consisting of a sequence of named members of various types Statement 2 A structure is a object that contains at different times, any one of the several members of various types Statement 3 C is a compiled as well as an interpretted language Statement 4 It is impossible to declare a structure or union containing an instance of itself A. all the statements are correct B. except 4 all are correct C. statemnt 3 is only correct D. statement 1,3 are incorrect either 2 or 4 is correct 7. consider the following program listing and select the output #include<stdio.h> main ( ) { int a=010,sum=0,tracker: for(tracker=0;tracker<=a;tracker++) sum+=tracker; printf( %d\n,sum); } A. 55 B. 36 C. 28 D. n

For Jobs Anywhere In India, Register At [Link]

For Placement Papers & Interview Questions Of Other Companies, Register At [Link]
[Link] the line numbers , that are valid according to the ANSI C standards? Line 1: #include<stdio.h> Line 2: void main() Line 3: { 4 : int *pia,ia; 5 :float *pafa,fa; 6 :ia=100; 7 :fa=12.05; 8 :*pfa=&ia; 9 :pfa=&ia; 10 :pia=pfa; 11 :fa=(float)*pia; 12 :fa=ia; 13 :} a. 8 and 9 b. 9 and 10 c. 8 and 10 d. 10 and 11 8. What is the o/p of the follow pgm? #include<stdio.h> main() { char char_arr[5]=ORACL; char c=E; prinf(%s\n,strcat(char_arr,c)); }

For Jobs Anywhere In India, Register At [Link]

For Placement Papers & Interview Questions Of Other Companies, Register At [Link]
a:oracle b. oracl c.e [Link] 9. consider the following pgm listing #include<stdio.h> main() { int a[3]; int *I; a[0]=100;a[1]=200;a[2]=300; I=a; Printf(%d\n, ++*I); Printf(%d\n, *++I); Printf(%d\n, (*I)--); Printf(%d\n, *I); } what is the o/p a. 101,200,200,199 b. 200,201,201,100 c. 101,200,199,199 d. 200,300,200,100 10. which of the following correctly declares My_var as a pointer to a function that returns an integer a. int*My_Var(); b. int*(My_Var());

For Jobs Anywhere In India, Register At [Link]

For Placement Papers & Interview Questions Of Other Companies, Register At [Link]
c. int(*)My_Var(); d. int(*My_Var)(); 11. what is the memory structure employed by recursive functions in a C pgm? a. B tree b. Hash table c. Circular list d. Stack 12. Consider the follow pgm listing? Line 1: #include<stdio.h> 2: void main() 3: { 4: int a=1; 5: const int c=2; 6: const int *p1=&c; 7: const int*p2=&a; 8: int *p3=&c; 9: int*p4=&a; 10:} what are the lines that cause compilation errors? a.7 b.8 c.6 and 7 [Link] errors 13. what will be the o/p #include<stdio.h>

For Jobs Anywhere In India, Register At [Link]

For Placement Papers & Interview Questions Of Other Companies, Register At [Link]

main() { inta[3]; int *x; int*y; a[0]=0;a[1]=1;a[2]=2; x=a++; y=a; printf(%d %d\n, x,(++y)); } a. 0,1 b. 1,1 c. error d. 1,2 what is the procedure for swapping a,b(assume that a,b and tmp are of the same type? a. tmp=a; a=b;b=temp; b. a=a+b;b=a-b;a=a-b; c. a=a-b;b=a+b;a=b-a; d. all of the above

For Jobs Anywhere In India, Register At [Link]