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 2024 Latest placement papers of this company
