Oracle visited our campus for placement this year as well. The written test was conducted by PAC on 21st of july 2007. The names of the students shortlisted was displayed on 24th night as the interview was supposed to be held on 25th and 26th.
I was shortlisted for the interview and here is my experience in the interview.
Round 1 :
First of all, i was asked why am i in formals with tie? Next, i was asked about my favourite paper for which i replied DBMS. Now the questions started :
------ if i open a SQL session and update the value of
value of a quantity 'x' to 7 which was initially 5. This is neither
committed nor aborted. Now in another session without closing the first
session if i try to print the value of 'x' , then what would be printed?
again if in this window i
try to update the value of 'x' as 9 and this process is also neither committed
nor aborted. Now what value of 'x' will be printed?
------i was asked to sort an array of strings? I wrote that in JAVA
easily.
------i was asked to write a code which could output the entered rational
numbers in the simplified form like if the input was 78/36, the output should be
13/6.
------i was asked how memory is allocated when an object is created in java
and how can we create references for any object and what would happen if the
original object is set to null?
------then i was asked about my experience in the coding and debugging
contests.
------the gentleman also gave me 2-3 puzzles which i solved pretty
easily.
------and many more HR questions.
Finally i was selected for the 2nd round of interview.
Round 2 :
The huge man asked my favourite subject. When i said "DBMS", he asked ' r u sure ' to which i replied in affirmative. Then he asked my favourite topic to which i replied 'transaction management'.
------i was asked the two phase locking protocol which i explained very
well.
------then he asked me application of locks on the data items in real life
with full detail which i explained by taking example of the stock market.
------then i was asked to explain how can we avoid the occurence of
deadlock and how to detect and recover from the deadlock if occured?
------he asked then to design a dictionary and write the code for searching
any word in the dictionary and later he asked me to write the code for the
binary search?
at this point of time the huge gentleman was convinced and satisfied as well with my answer and then he started asking me puzzles and he asked around 6-7 puzzles and i solved them all which led me to the third round of the interview.
Round 3 :
Here i was interviewed by the senior director who asked me to write the toughest code which i had ever written and after that he came straight forward to DBMS and asked me a lot of practical questions of the same.
------he asked me to design a database for PAC which should contain all the
information about the test takers necessary for analysis while preparing the
shortlist for interview.
------then i was asked to change the design if there was a change in the
test pattern.
------then he asked a few HR questions after which i was asked to wait for
the result.
All other guys were being called for the fourth and final round which was a complete HR by the lady but i was not called for the same. So, it was clear to me that i have been eliminated.
The interview was quite confidence booster for me particularly.
No comments:
Post a Comment