Oracle interview experience UVCE (3)

Oracle Interview Experience - 3


CONTIBUTOR :  Tushar Das

STREAM : CSE - Batch of 2018


The recruitment process consisted of 3 rounds- 1. Online Test, 2. Technical Interview, 3. Managerial + HR Round
It was a pool campus in BMSCE , in which 10 colleges had participated.
1. Online Test
Online test was for 2 hours. It had questions on Logical Reasoning, Aptitude, English comprehension and Technical questions. Technical section had questions on database management, java and c/c++ programming as well. Most of the technical questions were based on tree concepts(usually output based questions).
Questions were bit lengthy. But you can answer them if you are patient enough.
2. Technical Interview
Basic questions from C/C++ concepts
  1. Explain different types of Constructor.
  2. Explain OOPs concepts
Java Questions
  1. Difference between abstract class and interfaces.
  2. Explain Method Overriding and Method Overloading.

Database Management Questions
  1. Explain Normalization.
  2. Write a query to count number of teachers in each department (In a usual college database scheme).
  3. Explain Joins .

I had mentioned Python in my resume. So Questions on Python was asked
  1. Difference between shallow copy and deep copy.
  2. What is meant by *args and *kwargs?
  3. What are the operations you can do on dictionaries. (Retrieving all the keys, Deleteing an entry,etc.)

3. Managerial + HR Round
  1. Tell me about Yourself.
  2. I was asked to explain my final year project and question on that was asked.
  3. Asked me to explain my mini projects. Based on my database projects he asked me to write some queries and the relational model.
  4. What you know about Oracle?
  5. Do you plan for higher studies?
  6. Do you know on which area will you work , if you are recruited? (This was informed in Pre-Placement Talk).
General HR Questions. They want to know how good is your communication skills and how much passionate are you about the company.
Few candidates had 1-2 more rounds of Managerial interview.

Suggestions
Java and Database Management is a plus point.
Be confident. Interviewers are very friendly. Tell you don't know the answer , if you aren't confident, it's absolutely fine.

All the Best.

oracle campus placements logo
#Oracle

Comments