ORACLE-2004

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

paper having two parts.

part 1: apptitute test -30question (20min)

part 2: technical Test -30question (20min)

part 1:

1)find the range of x*x -5x+6>0

X<=2 ; X >=3

2)if 5x*x+14*x+k=0 having two reciprocal roots find the value of k.

3&4)two sentence are given ,in between four sentence are given in

change order .

(like between 1 & 6 ,abcd four sentence are given 1 a b c d 6)

Find the correct order?

5)if first term of AP is 5 .16th term is 45.find the sum of first 16

terms.

6)x,y and z are odd no. not necessarly in sequence.then y=?

(1)mean of x and z is 114.

(2)mean of y and z is 113.

Ans: 115

7)ram is 27 year old then mohan.after 7 year ram age is thrice as mohan

age .find ram age?

Ans : 67/2

8)if three tapes are filling a tank of capacity of 500lit with speed of

30lit/sec,48lit/sec and 36lit/sec. Find after how long time tank will

fill?

Ans : 500/114

9)find the root of given eq x-2/(x-1)=1-2/(x-2) if possible.

Ans : x = 0

10)find the point of intersection of \

15x+9y=15

5x+3y=21

Ans : NO

11)suppose in a pot 20 cards are there label 1-20 on that. find the

probability of getting two prime.

Ans : 8/20 = 2 / 5

12)in an island three persons are there Jam ,Dam and Sam .sam having

pencil,dam having cap and Jam having book .we have find who is author

among them if.

(1)Sam says ,Jam is author but author wearing cap.

(2)Dam says ,I am author ,but author not having cap.

(3)Sam says, I am author ,but author having note book.

Find who is author?

Ans : jam

13)Jo ,Do and So are three person.

(1) So says Jo is football player, I also football player.

(2) Do says Jo is football player, I also football player.

(3) Jo says Do is football player, I also football player.

Find the football player player among them.

Ans : jo

14-16)question based analogy . like LION:CUB find the pair in given

choice.

17)in a basket 3 mangos,4 apples and 4 bananas are there. Find no of

ways we select randomly 3 fruit from basket?

18) if a^x=b^y=c^z and b^2=ac then

find x+z/xz=?

Ans : 2/y

19)(loga)^2-(logb)^2 = ?

ans :- logab-loga/b

20)in a 60 liters of mixture of spirit and water is 7 %.

in order to make water 19%,how much water should be added.(some

thing like this)

21-25)A one and half page length passage will be given and 4 to 5

questions will be asked based on this passage.

26)

technical part:-

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

pattern: 1) pl/sql--->7 quest

2) java--->5 quest

3) c & pointers--->9 quest

4) dbms and dfd's--->5 quest

5) ds--->4 quest

some quest are here:-

1.what is not a c- storage class

Ans.stack

2.if dba creates one user what are the privilages the user will get?

3. which keyword is used to const in java

Ans. final

4.char *array[4]={"some string"}

printf("%d",&array[4]-(array));

Ans.4

5.remote object will be in the package

Ans.java.net (verity it)

6.#define sq(a) (a*a)

printf ("%d",sq (3+2));

Ans.11

7.#define max 20

printf ("%d", ++max);

Ans.lvalue required --- error

8.printf ("%d",sizeof (2>3?4?:4:3?4:2));(some thing like this)

Ans.syntax error

9. what is important of free().

10.property of constructor in java program.

11.impotance of macro.

12.underfolw condition of stack.

(1)empty,2)push,3)pop,4)none)

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

1)Which of the following is not a storage class in C?

Static

Register

Extern

Stack

2)Which of the following 'return' statement is correct?

return, return;

return(1, 2, 3);

return(return 4);

(return 5, return 6);

3)The second argument to fopen() function is?

char

const char *

int *

FILE *

4)What is the output of the program?

#include <stdio.h>

void main()

{

char buffer[10] = {"Genesis"};

printf(" %d ", &buffer[4]- (buffer));

}

3

4

0

Illegal pointer subtraction

4

5)If "arr" is an array of 5 x 5 dimension, arr[2][4] is same as

**(a+3+4)

*(a+3)+*(a+4)

**(a+3)+4

*(*(a+2)+4)

APTITUDE 30 questions

Log37

1: ------- = ? ( Log67 )

1 + Log32

2: log(a-b) = log a - log b; then a = ?

(b/(b2+1));

3: 3 black 7 white balls ......... prob of drawing 2 white balls ? (7/15)

4: In a lock of 4 rings there r five characters how

many unsuccessful attempts can be made ? (624)...

5: sqrt(6+sqrt(6+sqrt (6 + .................))))) = ? 3

6: a solution is prepared by mixing two solution

with sprit 20% & 60%...In

what ration they should be mixed to get the 50% sprit

in resultant solution .

(1:3)

7: X2 - (A-3)X +(A+3) = 0

for what value of A the sum of square of roots will be

least ? (A=2);

8: 'a' number of persons work daily 'b' hours to

produce 'c' items. If 'd'

persons walks away from the group what will be the

number of hours to

produce 'c' items. ? (ab/(a-d))

9: - 13 Passage

14 - 18 venn diagram.

19-22 picking based (VERBAL);

23-25 picking odd once out (words )

26: m = ax , n = ay mxny = a2(x+y) find 1/x + 1/y? (1)

27 xy - 2y - 6 =0;

x <> 2 x >2 ...

y is always postive.

28

The diameter of circle can be determined from

1.area.

2.circumference.

Ans either of them..

29:

sum of 2 no. is 7 & product s 10 fnd larger number.

30:

TECHNCAL :

It will be really tough. They will manly concentrate on

PL/SQL

Java.

C.

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

2. What will be the result of the following program?

char*g()

{

static char

x[1024];

return x;

}

main()

{

char*g1="FirstString";

strcpy(g(),g1);

g1=g();

strcpy(g1,"SecondString");

printf("Answeris:%s", g());

}

(A) Answer is: First String

(B) Answer is: Second String

(C) Run time Error/Core Dump

(D) None of these

3: which will not complete the transaction ....

(UPDATE).

4: PL / SQL loop can be replaced by which loop to get

least number of steps.

5:regarding USER_NDEX.

6: which language is used by end user to manipulate

dbms.

DML

7: what can not be used in object names.

8: what is used to collect information from more than

one table ( JOIN).

9: program on java.swng.

10: problem on JNI

11: something on extendability or searializability

12 some more c codes.

13 on queue defintion.

14 what s orthogonal matrix.

15 Peep stack.

16 reg . class.

17 compiler intilized storage clases.

18. whch storage class allows class to be initialized

in a class.

19 on set font

20 on redundancy ...

Oracle Paper

consists of 45 questions 45 minutes.

15 java

15 SQL and PL/SQL

15 C (including data structures).

A little bit tough.

some of the questions i remembered are

1. question on bubble sore

2. quick sort complexity

3. heap sort SPACE complexity.

4. char *p = "Oracle India";

p[5] == 'l' ? printf("Orcle") : printf("India")

5. main()

{

int i=5;

recursive(i);

}

recursive(int u)

{

if(u > 0 )

recursive(u-1);

printf("%d", u);

}

6. question on function pointer.

char *(*(*x())[])()

7. GRANT command question

8. about MINUS set operator.

Java

9. RandomAccessFile

10. super class base class simple question

11. what is overridden

12. StringBUffer question

overall test

1. questions on java are based on oops concepts and

some are language based like StringBuffer class, RandomAccessFile

and File classes.

2. SQL/PLSQL, see all commands in SQL and exception, cursors, in PLSQL.

3. c is fine, but you should be fast in finding out answers so that you can spend

time on other questions.

4. i didn't get arithmetic questions.

**Click here to Download 2023 Latest placement papers of this company**