Application:

Oracle (Server Technologies) came for campus hiring at our college (AIT Pune) on September 11th.

Interview Process:

The process was a two-day event.

1. The first round consisted of an online test covering English, Logical, and Quantitative sections, networking basics, C language, and OS concepts.
2. The second round involved on-paper coding (one problem) and puzzle-solving (two problems).
3. Next was Technical Interview Round I, where I was asked questions primarily on Computer Graphics, Databases, and OS concepts.
4. Following that was Technical Interview Round II, which focused mainly on my projects and lasted for approximately two hours.

Each interview round was an elimination round, so every step of the process was crucial.

1. Online test comprised of basic aptitude, verbal, logical, and technical questions. Most of them were easy.

2. On-paper coding question was to find the smallest substring consisting of 'a', 'b', and 'g' characters. The other two questions were analytical.

How will you put 50 RED and 50 BLUE balls in two given containers with infinite capacity, so that the probability of a ball taken out of the containers being red is maximum? I don't remember the other question.

1. Technical Interview - I was mainly related to theoretical computer graphics, database, and OS concepts like raster, random scan, cursor, pixel, resolution, DPI, IPC, normalization, NoSQL vs SQL, thread architecture, etc.

2. Technical Interview - II: Project discussion (interviewer 1), deleting a node in a heap (interviewer 2), find the nth highest salary in a table (interviewer 2). I wrote 4 queries to find the nth highest salary.

Basically, they test your overall knowledge of all your subjects and how strong your basics are. They delve into deep intricacies of each subject to know the extent of your grasp on those subjects, plus your projects.