Browse > Home / Placement Papers / Oracle Placement Paper 13th May 2005 at Hyderabad

Oracle Placement Paper 13th May 2005 at Hyderabad

December 26, 2007

Overall Recruitment Strucutre
6 rounds
1st round-apptitude written 14/30( 30 min)
2nd round tech written 24/30 (30 min)
3rd round Technical round_1 (more than 1.30 hr)
4th round Technical round-2 (more than 1.30 hr)
5th H.R_1 (more than 1 hr)
6th H.R_2 (lasted for 15 min)

1st Round:
1 Cartesian Product can be achieved by using join
which involves a condition
a, no of tables-1
2 Bitmap tree & Binary tree
3 Outer join
eg: emp.deptno=dept.deptno(+)
4 Changes made to database through PL/SQL block will
be effected due to ——— when
ever user executes that form or ……….
a, Commit in PL/SQL blk
b, end of PL/SQL
c, After leaving/ending the session
d,
5 Select dept,avg(sal)
from emp
group by job;
Find out the error in which line it is
6 For loop of a cursor is—–Implicitly opened &
closed
7 The implicit cursor attribute that does not work
is%found,%notfound,%isopen,%rowcount
8 Which of the following is not a cursor attribute
%founf,%notfound,%rownumber,%rowcount
9 Insert
save point
update
save point
create
rollback
delete
a, only delete rows

10 Proc_a calls Proc_b calls proc_c
there is an satatement in Proc_b where we have a
divide by zero error but u dont have any
exception in Proc_a.so can u write any exception to
overcome it
a, zero_divide in proc_c: Not confirm check it

11 dont remember the remaining but they were simple

3rd round;;;;;
1 Exception: def
asked Eg’s NO_DATA_FOUND

2 Begin
code
Exception
when others then
—–
—–
when zero_divide then
—–

any error?

3 emp dept
empno deptno
ename dname
deptno
write a query to get empno,ename ,deptno,dname

4 deptno emp
10 40?
20
30
40

5 select deptno,count(*)
from emp
group by deptno;

related scenario
ename empno
deptno
x a
10
y b
20
z c
30
d
40
count(*) -> 4 rows
count(ename) ->3 ignores null valued rows

6 Foreign key can hold null value

7 constraints: def & types
diff between(b/w) unique & Primary key
constraints

8 Trigger : syntax
How do u identify that its for
insert/delete/update: thru
if(INSERT)
code
9 Puzzel 3 switches 3 bulbs in a room
u have to go into the room watch them ,come
out of room and select a switch
so that there is a correspondence with the
bulb i.e., if 1st switch-1st bulb and
so on, if u select firist switch it should on
the first bulb

10 any all

11 insert
update
create
delete
rollback
then deletes rec

12 insert
update
create (does not create & results in err)
delete
rollback
then deletes rec becoz ddl is precceded and succeeded
by a commit

13 types of commands
DDL,DCL,DML,TCL

14 diff b/w truncate & delete
15 substr(),instr(),replace(),translate()

Tech2,,,,,,,,

1 write a C prg to check the occurance of ‘ac’ in
‘oracle’ and the no of occures of ‘c’
in ‘oracleinc’

2 if u get a job offer with 20% hike in sal from
Microsoft then will u leave ur
company which u have joined 6 months back

3 Not so good in sql? i said so so
so we dont provide any trainning so how will u cope
up

4 exp ur work in ur present company(modules)
gave a scenario which is like below
two table were given test(testname,testid)
and test_det(testid,marks)
write a query to print in the below format
testname testid status count(*)
FAIL
PASS

select
testname,testid,decode(Marks,greatest(Marks,40),”PASS’,”FAIL’);

5 Data given was
‘Pragati’,'PRagati’,'pragati’…diff formats
so now write a query to get all the data
select name from demo
where lower(name)=’pragati;
can we write lower(name)=lower(pragati);
what does lower take as an argument

6 does oracle support function overloading
dont know/not sure
so give eg of any function in sql which supports
overloading
substr()
so how does it store internally:dont have idea
took eg of overloading in java and asked how does it
store:gave some rough
idea which was correct: each function is stored
differently i.e., if u have
func(int x,char y) and func(char x, int y)
so it sotores them differently
so he said its this way that its also stored in oracle

7 does oracle support oops:yes,objects

8 explain oops cponcept

9 some java ,c,c++ questions

10

H.R……….1

1 tell about yourself

2 why did u come along way from gurgaon to hyd for
interview: ooportunity knocks once

3 why did u not join eng

4 why did u get less rank in ICET

5 what’s ur goal:

6 why only 75% in MCA
correction tough
university and collegest highest? 78 and 80
why so?give exp

7 support that ur hardworking
gave some eg of college …convinced him

8 who is ur role model?support ur ans

9 what is ur gr*achievement

10 questions on final year project and degree project their
formats

11 apt question

in a pipe through which water is flowing is 1/3rd
full what is its volume: and
ans is in the question i.e., 3 times

H.R—–2.

1 short term goal7 yrs:team leader
long term goal>14 yrs: CEO ,
so what would u do to achieve it: i think it needs to
have managerial skills so as to manage so would
like to do MBA and…..

2 how much r u expecting:anything acc to oracle
standards

Under Placement Papers

Related Posts

Enter your email address:

Delivered by FeedBurner