Try to follow the documentation provided with the
software.That will do.Ivan bay... is also a good book.
         
It was an referral walkin
There were 6 rounds :

1st round-apptitude written 14/30
2nd round tech written 24/30
3rd round Technical round
4th round Technical round
5th H.R
6th H.R

1st Round: Follow oracle previous question papers
2nd Round:Sql and Pl/Sql
  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
%found,%notfound,%rownumber,%rowcount
ans: %rownumber
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()

4th round: 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

ans:  1st thought wow!!!!!!!!!!!!!!!!
        2nd tought  good but u cant go on jumping if
do that u may get good sal but not good
         hold on subject so i will not prefer

3,Not so good in sql? i said so so
   so we dont provide any trainning so how will u cope
up gave some expl
4,  expl ur present work in JAMIA,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

7.does oracle support oops:yes,objects

8.explain oops concept

9.some java ,c,c++ questions    
  
H.R..........1

1< tell about yourself

2< why did u come along way from gurgaon to hyd for
interview: ooportunity knos 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
7<  support yourself that ur hardworking
gave some eg of college ...convinced him

8< who is ur role model?support ur ans
9< what is ur gr8 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

The main thing is their criteria which they will not
compromise they r looking for broadminded people who r
intelligent,hardworking and having good communication
skills

never try to bluff the interviewer