ORACLE Interview question and Answer
There were all kinds of question..
1.6 quants
2.6 verbals
3.critical reasoning
TECHNICAL
1.Oracle(16 qns)
2.C/C++( 12 questions)
3.java( 2 qns)
1. A circular plate of uniform
thickness has 12 holes in it with a
radius of 1cm. It loses 1/6th of the
original weight. What is the org. wt?
2. a man keeps one chocolate for
himself and divides the remaining
chocolates into three. One person out
of this has one chocolate for himself
and divides the remaining chocolate
into 5. one out of this has a
chocolate with himself and divides the
remaining into 6 the 6 persons get
equal no of chocolate . find out the
original no of chocolates.
3. there are 8 beads in a necklace. 4
out of it is fixed.
4. what is the minimum value of
xy^2+yz^2+x^2z.. minimum value of this
data is obtained with
a. if x,y,z = some value..
b. ….
c. …
d. what is sufficient
5.verbal:
arrange the sentences in proper order.
5. if ‘a’ not equal to ‘b’
implies that b = a and a=b then find
‘a’ not equal to (a-b) and b not
equal to (b+a)
6. a room (9*9) must be filled with
square tiles with alternate black
and white in a checker board fashion.
The four corners of the room must
have black square tile. What is the
length of the square tile?
7. a plate with uniform thickness has
10 holes drilled in it each of 1
cm radius reducing the total weight by
1/6. what is the total radius of
the plate?
8. 64/4*4
answers 4,16,64,12
9. conditions true for linked list-
10. doubly linked list
11. circular linked list
IT SOLUTIONS
Logical reasoning
Verbal
GRE type comprehension
Yes, no, cant say type
C apti
1-15
ans:(c,b,b,c,a,c,c,b,b,b,b,c,d,b,a)
time : 60 min
aptitude 35 qns
C-30 qns
C++-30 qns
1. no of triangles in the given fig.
2. no of cubes in cuboid
3. 16 balls in four colours. Atleast 2
in one colour number of ways in
which ….(permutations and
combination)
4. 3 computers 2400 each 1-20% profit,
20% loss …total gain or loss
5. 200 employees. Twice a day- tea 100
cups available . 1 cup –0.30
paise
broken cup-0.90 paise . at the end of
the day24 rupees is paid what is
the no of broken cups?
6. A-10 B-15 days
7. numerator / denominator…denominator
+4=numerator.
Numerator/(denominator +10)=1/8
8. 3*#*# cube is to be painted(outside
face)
9. 1*1*1 taken out at least 1 side
painted
10. # define inside main()
a[2][3][4] ={( ),( ),(
)};
printf a,*a,a*a,***a.
starting address is given
11.enum {a=1,b,c,d,f=60,y}
y=? 61
12.my prog 123
main(int argc,char *argv[3])
……………….
J=0;
J=J+atoi (arg[ ]);
Find j.
a)123 b)”123” c)6
13.main(int arg c,char *arg v[ ])
j=0..
j=j+a+(arg[ ])
14)writing the equation for a question
we get 500x=9000+400x.find x.
i) 123 ii)”123” iii)6
15.char a[ ]={‘abcde…z}
size of [a]
ans: 26,27,28
16) k=2,j=3,p=0
p=(k,j,k);
printp;
ans: 2
17)int I=1234.5678
printf(“%d”,I)
18)arr[]=[5,6]
printf(“%d”,arr[1.6]
ans:compilation error
20)
main(int arg c)
{
int len,
p is a pointer;
++p->len
ans:
1)pointer is increased
2)len is increased
3)no change
1. AB is a fixed vertical wire and C is
a small fixed peg,8 cms from Ab. PCQ is a string 30 cms long
supporting a marble Q and attached to a small ring P which can slide
on AB. Initially Q is 19 cms below C. if Q is pulled down by 1 cm ,
how much does P rise?
a.2.3cm b.1.55cm c.1.37cm
d.1.83cm
2. when I was married 10 yrs ago, my
wife was the sixth member in the family. Today my father died and a
baby was born to me. The avg. age in my family today is what it was
when I was married. How old was my father when he died?
a. 50 b. 60 c.70
d.indeterminate
3. if a/(a+b)=b/(b+c)=c/(c+a) which of
following is true?
a. a+b+c=0 b.a2=b2=c2=0 c.
a2=b2=c2 d.none
4. 10% sugar solution is one where 10 gm
sugar is mixed with 100 gm water. What will be the concentration of
200gm of 20% solution when 100 gm water is evaporate from it
a. 40% b. 36% c.50% d.48%
5. a town is supplied with water from a
reservoir that is fed by a stream that provides the same amt. Of
water everyday. If 30000 gallons of water are used everyday, then the
supply fails after 25 days and if the daily use is reduced by 5000
gallons the supply lastsfor 3 days more. How many gallons water can
be used with out the supply ever failing?
a. 10000 b.15000 c.16667
d.none
6. in the above problem, if the MD of
the office wants those 5 phone numbers to be successive numbers, then
how many sets are possible?
a. 103*(10 4C5) b. 103*(104-4)
c. 107 d. none
7. two men complete 1/3 of a task in 2
days and 3 boys do the 1/5th of the work in 1 day. Now a woman,a man,
and a boy together finish 1/5th of the work in 1 day. In how many
days will 4 women finish the work?
a. 5 b.4 c. 10 d. 20
8. find the error in the fragment:
1. although my friends
2. were in trouble
3. I was confident that everything
4.would turn alright
9. choose the set in which the sentences
are logically consistent:
A. some fish are carnivores
B. Whale is a fish
C. Whale is a herbivore
D. Whale is not a carnivore
E. Not all fish are
carnivores
F. no fish is a carnivore
10. 1.FDB 2. FBD 3. ADE 4. CBE
A. all native Australians are
aborigines
B. aborigines are good at lighting
flames
C. Olympic flame is lit by a
aborigine
D. Olympics are held in Australia
E. Only good natives can light
Olympic flames
F. Any Australian can light the
Olympic flame
11. The interior angle of a regular
polygon is ¥è and ext is ¥Õ what is the no of diagonal of regular
polygon
A. ¥è=2¥Õ B. ¥è>=50¢ª
12. Arrange the sentence ABCD logically
sequence between sentences 1-6
1. understanding the game of tennis is
quite difficult from getting into the court and playing a good game.
A) there is no substitute for practice B) exactly the same applies
to skills, cooking, playing to piano or writing computer program C)
the more you practice a skill the better you will be able to use that
skill D) skill here to be practiced 6.if you want to be a master
thinker you will have to practice the thinking skills set out to you
1. BDCA 2. ABDC 3. BCAD
4. DCBA
Analogy:
13. Astronomy:stars
1. celestial bodies:humens
2. sky:relationships 3. psychology:mind
4. telescope:books
14. smoke:pollution
tides:moods 2. rain:mountain 3.
virus:disease 4. air:breaze
TECHNICAL
1. select deptno, count(empno) from emp
where count(empno)>=5
group by deptno;
identify the line no which contains
the error
a. 1 b. 2 c. 3 d.
statement executes
2. FETCH c1 INTO C1 rec;
IF c1% FOUND THEN
¡¦¡¦¡¦¡¦.executable
statements
END IF;
How would the same functionality as
shown in the sample code above be executed if a cursor c1 were being
used in DBMS_SQL
A) IF
DBMS_SQL.IS_OPEN(cursor_handle)THEN
executable statements
END IF;
B) IF
DBME_SQL.FETCH_ROWS(cursor_handle)>0 THEN
executable statements
END IF;
C) IF CDMS_SQL.
LAST_ROW_COUNT(cursor_handle)<=DBME_SQL.TOTAL_ROWS
(cursor_handle)THEN
executable statements
END IF;
D) IF DBMS_SQL.
FETCH_ROWS(cursor-handle)=0 THEN
executable statements
END IF;
3. create or replace package body pkg1
as
x number:=1;
produce p1(a number);
end pkg1;
create or replace package body pkg1
as
y number:=1;
n1 number;
n2 number;
procedure p1(z number)
is
dbms_output.put_line(z);
endpkg1;
identify the packaged variables
a. x b. y c. z d. n1
4. create of replace trigger tr1 before
insert or update or delete on emp begin
if : old.sal c: new.sal
then
raise_application_error(-200001,¡¯The sal cannot be decremented¡¯);
endif;
end;
what changes must this program undergo
inorder to make the trigger successfully
a. make it as a st. level trigger b.
add a when restriction c. make it as a row level trigger d. such a
trigger cannot be created
5. what will happen if you try to
compile and run the following code
public class my class{
public static void main
(string arguments[ ] {
a
method(arguments);
}
public void a method(string
[ ] arguments) {
system.out.printin(arguments);
system.out.printin(arguments[1]);
}}
A) error cant make static referance
to void method
B) error method main not correct
C) error array must include
parameter
D) a method must be declared with
string
6. what will be printed if this code is
run?
Java myprog good morning
Public class myprog {
Public static void main
(string arg v[ ])
{
system.out.printin(arg v[z])}
}
A) myprog B) good C)
morning D) exception raised;
Java.lang.array Index out of pounds
exception
7. OUTPUT OF THE FOLLOWING PROGRAMS:
public class myclass{
static int;
public static
void main (string argv[ ]){system.out.print\n(1);}
A. error B. null
C. 1 D. 0
8. which are invalid statements
1. int a=5; 2. int a=5,char y;
3. int a=5;char y;
# main()
{ int a[2]={10,20};
calc(a); printf(¡°%d¡±,a(0);}
calc(int*x)
{*x=*x+100;}
A.10 B.120 C. 110
D. error
9. int j: main() { int a=j;
printf(¡°value of A is %d & j is %d,a,j)}
A. error B. null
C. 1 D. 0
10. what is true about compound
statements in C
A) a compound statement must contain
at least one statement
B) a compound statement cannot
contain another compound statement
C) a compound statement cannot
contain any function calls
D) none of the above
11. which of the following can be
interpreted as a data dictionary
A) a table of cursors
B) a ¡°table of tables¡±
containing a list of all the tables in the database
C) a table of pointers containing a
list of all the rows in the database
D) a table of objects containing the
list of all the records in the database
12. you want to enface re fractional
integrity in your RDBMS, which of the following RDBMS features allow
you to achieve this without complicated
A) foreign key constraint B)
primary key constraint C) check constraint D) not null key
constraint
13. data modeling entries usually have
one or more at which one of the following
A) synonyms B) keys
C) children D) relationship
14. which of the following is a potential
subjected to a database with a lengthy and complex primary key that
is used frequently by and users for single row queries
A) horizontally seg. a table into
multiple tables B) vertical seg. a table into multiple tables C)
add foreign keys D) add more indexes
15. the top most mode in a stack
A) contains address of a null memory
location B) contains address of 1st node
C) contains null instead of address D) none of the above
16. the POP operation retrieves
A) last element inserted B) 1st
element inserted C) both A&B D) none
Hi... Here is another collection of oracle interview questions
ReplyDeletehttp://www.infibee.com/interview-questions/oracle-questions-and-answers