oracle

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 proj and degree proj 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 goal<4 yrs from now: get good hold on

Oracle

middle term goal>7 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

3< u will be getting a mail on monday



never try to bluff the interviewer

tell him u dont know the ans or u r trying or

somethink of that sort

ok bye for now





that all from me

ALL THE BEST