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
|
