Oracle interview | Fresher | Application Developer | IC-2 level
Challa Vasanth Rao
1090
CareerFeedbackCompensationInterview

I was waitlisted!
On-campus opportunity | NIT Warangal | Mechanical Branch
CTC : 35 LPA (1 year CTC) around 65 LPA (overall CTC)
CTC Breakup : 18.5 LPA Base

Round-1

Two Puzzles

  1. 10 coins Heads and Tails, you're blind folded and split into two groups such that both are equal.
  2. Number of equilateral triangles that can be formed with 6 match sticks.

Two SQL questions

  1. Joining tables and finding Nth highest salary, follow up asking different ways to achieve this.
  2. In table, they've given percentage and asked to convert into grades. I mentioned about CASE statement then one more follow up question asking to do without case. Where it can be done by creating a table for percentages range and their grades and then joining.

One Coding Question

  1. Where given "DDMMYYYY" format write code for validating whether the date is correct or not?

DBMS question

  1. Where they asked about ACID properties with examples.
  2. Normalization and uses cases.

About my internship experience and project asked many questions
OOPs concepts four pillars and usecase in my project.

Round-2

Where I have been asked 4 DSA questions

  1. First I have given an array and I need to find an subarray such that min. Size is m and sum of element is k. And follow up question on DP.

  2. Finding second min. sum in an Binary Tree.

  3. A word problem where it's showcases to use Dijkstra's Algo followed by Bellaman Ford ( remember constraints).

  4. I have given a binary tree and mirror placed at bottom and I need to return all the leaf nodes where they leads to root. Basically tree into graph.

Round-3

HR round

  1. Where I have been asked about my branch, why do you want to switch into IT industry?
  2. About my minor degree.
  3. About my internship experience at LinkedIn, and my project. Where there is more discussion on my project asking alternative approach to a chunk of problem why it doesn't work, testing my confidence whether I have tested every approach or not.
  4. OOPs SOLID principles
  5. Asked about what Oracle does and why do you think that you can fit in this role?
  6. Asked about how did you manage Core and learning technical skills despite maintaining good CGPA.
  7. At last, any questions from my side.
Comments (2)