Latest 2007 December Placement Exam Oracle in Bangalore

Model Questions From the Placement Exam conducted by Oracle Bangalore in 2007 December.

1. What is the output of the following program?
#include
#include
void main( )
{
int a=5,b=7;
printf(“%d\n”,b\a);
}

A. 1.4
B. 1.0
C. 1
D. 0


2. What is the output of the following program listing?
#include
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?
#include
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 & chose collect answer

#include
void main( )
{
inta[10],k;
for(k=0;k<10;k++)>
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

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 & select the output
#include
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 8.Spot the line numbers , that are valid according to the ANSI C standards? Line 1: #include
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 & 9
b. 9 & 10
c. 8 & 10
d. 10 & 11

8. What is the o/p of the follow pgm?
#include
main()
{
char char_arr[5]=”ORACL”;
char c=’E’;
prinf(“%s\n”,strcat(char_arr,c));
}
a:oracle
b. oracl
c.e
d.none

9. consider the following pgm listing
#include
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());
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
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 & 7
d.no errors

13. what will be the o/p
#include
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 & 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


READ ANSWER and EXPLANATION

2007 December Oracle Exam Model Paper

Oracle Exam Model Paper for interview placement test



1. Three beauty pageant finalists-Cindy, Amy & 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 & 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 & 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 & 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 & 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 & bring back home. One day he gets free at 5.30 & instead of waiting for driver he starts walking towards home. In the way he meets the car & 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. & 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++) i="3;" i="func(i);" i="func(i);" g1="First String" g1="g();" b="&a[2];" ab="x;">left->right->data

ans: r->data

9:explain const char *ptr & 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

& 4 are sentese ordering when jumbled senteses given

& 4 are reasoning


READ ANSWER and EXPLANATION

2008 Oracle Corporation Placement Interview test paper 2

PAPER 3(this is very easy paper to land the job)

30 Questions. technical - 30 mins. - mostly on DBMS, Oracle(like what would be the output), C, C++, Java(2-3 Questions. on class & constructors) & data structures.



30 Questions. general - 30 mins. - 7 Questions. aptitude, more like English (filling up prepositions, same meaning, reading comprehension, four sentences would be given - you have to order them to form a paragraph, similarly four questions would be given - you have to say which one is a inference statement, which one is a judgement,etc.)



The technical test would be easy & general test would be little difficult.





In the interview, they asked me the following questions.

=============



1. what are the macros other than C macros (the macros in word,excel)

A macro in MS-word is used to group a sequence of jobs & make it as a button or keyboard shortcut.

Suppose, if you need always to draw a table containing 2 rows & 5 cols, you can start,record a macro &

make it as a button & put in taskbar, so that when you press it, you will be provided with a fixed table.


2. can you delete a column from a table. In oracle 9i, you can do it by the statement

ALTER TABLE table1 DROP COLUMN column1; In oracle 8,you can,t.



3. can you store a image in oracle & by which datatype? Yes, you can & it can be acheived by using a BLOB (binary large object) type & store upto 4GB in a single column.



4. have you used reports & forms in oracle?



5. have you written applications to retrieve stored images in a table?



6. some DOS commands & UNIX.



7. project desription (both academic & miniprojects,if any)



8. some situation questions like what would you do if your company is burning,etc.







PAPER 4



1. It contains 30 Questions of SQL + PL/SQL & the TIME allocated

is 30 minutes

STRICTLY!



2. After test (15 Mins.) a Oracle guy declared test results by announcing the full name of candidates & apologising to others. Very Polite.



3. Then another test for Programming is there.



4. After this they have to go for the round of Interviews.I remembered some questions from the Test Paper:

(I wish this will help others in their preparations)

(THESE QUESTIONS ARE IN RANDOM ORDER)



Q. DELETE FROM TABLE TempV WHERE ROWID IN

(SELECT ROWID FROM TempV WHERE ROWID IN (

((SELECT MIN(ROWID) FROM TempV

WHERE ... COUNT(*) > 1)))

UNION

(SELECT ROWID FROM TempV WHERE ROWID IN (

((SELECT MIN(ROWID) FROM TempV

WHERE ... COUNT(*) > 1)));



Q. When there is a failure in fetching the rows from a cursor...

A. %ISOPEN

B. %NOTFOUND

C. %FOUND

D. %ROWCOUNT



Q. SELECT ,ORACLE, FROM DUAL WHERE NULL = NULL;

A. ORACLE

B. NULL

C. ERROR OUT

D. NO ROWS SELECTED



Q. There is a question of Package body & Package Specification, they have provided the code for that describing the scenario of movie_tickets_sold & asked the programmer to insert a block of code...., where that code block to be inserted? In Package body? or in Package Specification?



Q. Which of the following operator is not used in Outer Join?

a. =

b. !=

c. &

d. OR



Q. PL/SQL uses which of the following

a. Early Binding

b. Late binding

c. No Binding

d. Deferred Binging



Q. followin is a database trigger,



CREATE OR REPLACE TRIGGER delete_row

ON DELETE did not remember the complete code for this ...

....



if table contains 100 rows & it is truncated, how many rows get

updated

a. 0

b. 1

c. 100

d. No rows updated


READ ANSWER and EXPLANATION

Oracle Corporation Placement Interview test paper 1

1. Three beauty pageant finalists-Cindy, Amy & 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 & 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 & 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 & 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 & 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 & bring back home. One day he gets free at 5.30 & instead of waiting for driver he starts walking towards home. In the way he meets the car & 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. & 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++)>



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} .


READ ANSWER and EXPLANATION
Take Advantage Of 25 of the finest Articles to help u prepare for the Placement Papers and Interview questions
You’d Never Guess How easy it is to get a job after reading these placement preparation articles

Here are 25 Placement Preparation Articles


"IMPORTANT NOTE"
We Update our site frequently and we want to keep you guys informed so enter your email in the top left hand box and click subscribe,so that whenever we post new papers it gets delivered right to your mail.



 

© New Placement papers | Latest Placement Papers