Oracle Recruitment Process

 Oracle Recruitment Process

Last Updated: 13 Aug, 2024

This article provides a detailed overview of Oracle's recruitment process for the on-campus hiring event, including the different rounds, types of questions asked, and interview experiences shared by successful candidates.

ROUND 1: Online Test (90 Minutes)

The first round was an online assessment conducted for 90 minutes, consisting of the following sections:

  • General Aptitude: 10 questions
  • Coding Skills: 20 questions
  • DBMS and OS: Questions related to Database Management Systems and Operating Systems
  • English: Questions assessing English language proficiency

Each section had a fixed time limit, and no extra time could be transferred between sections. Once you submitted your answers, you couldn’t make any changes. There were no negative markings for incorrect answers.

After this round, candidates were shortlisted for two different profiles:

  • Application Profile: 76 candidates were shortlisted.
  • Server Tech Profile: 39 candidates were shortlisted.

Server Tech Profile - Coding Round (1 Hour)

For those shortlisted for the Server Tech Profile, there was a one-hour coding round with two problems:

  1. Minimum Length of Unsorted Subarray (problem link: GeeksforGeeks)
  2. An overlapping intervals problem (The exact problem wasn’t remembered but was noted to be quite tough).

The coding round was conducted on Oracle Cloud, and there was no elimination after the round.

Interview Process for Application Profile

Candidates for the Application Profile had to undergo 3 technical interviews followed by an HR interview. The interviews covered a variety of topics, from programming questions to system design and communication skills.

Interview 1 (30-45 minutes)

In the first technical interview, the interviewer asked a mix of theoretical and practical coding questions:

  1. Find the frequency of each character in a string.
  2. Check if a string is a palindrome.
  3. Find the length of the longest non-repeating subsequence.
  4. Explain how Facebook works.
  5. Why is the finally block used in Java?
  6. Difference between Error and Exception.
  7. Print patterns using loops.
  8. Find the diameter of a tree.
  9. Reverse a linked list.

Puzzles:

  1. Given 12 balls, one is defective. Determine the defective ball and whether it is heavier or lighter, using only 3 weighings.
  2. The "Oranges and Apples" puzzle.
  3. The "Burning Rope" puzzle.
  4. Measure 9 minutes using two clocks, one with a 7-minute duration and the other with a 4-minute duration.
  5. Two trains travel in opposite directions, and a bird flies between them. Given the distance and speed, calculate the speed of the bird.

Feedback on coding, problem-solving skills, and communication was provided.

Interview 2 (60 minutes)

The second technical interview delved deeper into problem-solving and system design, with questions like:

  1. Josephus Problem: Solve the classical problem with a safe position.
  2. Discussed the project in detail.
  3. Difference between calloc and malloc.
  4. Given the input “cle”, return true if it is a substring of the string “oracle”, considering rotations.
  5. Print each word and its frequency in lexicographical order from a file.
  6. Find the 3rd and 4th highest marks among students using C.
  7. Dining Philosopher Problem: Solve the synchronization issue.
  8. Implement a custom rand() function.
  9. Why do we use graphs in computer science?
  10. Mirror tree generation and counting paths from source to destination.
  11. Check if a number is divisible by a power of 2.

Interview 3 (40 minutes)

The third technical interview focused on deeper concepts in programming, memory management, and databases:

  1. Detailed discussion on pointers.
  2. How do you return multiple values from a function in C?
  3. Use cases for a Self-Join in SQL.
  4. When do we use a Left Outer Join in SQL?
  5. Memory allocation for structures and arrays.
  6. More questions on DBMS concepts.
  7. Banker's Algorithm to prevent deadlock in operating systems.
  8. Difference between a compiler and an interpreter.
  9. Implement the Sieve of Eratosthenes for finding prime numbers.
  10. Discussion on future studies and career aspirations.
  11. General behavioral questions.

HR Interview

The HR round typically consisted of standard HR questions:

  1. Why did you choose Oracle?
  2. Why didn’t you pursue an MS degree?
  3. Package discussion.

Final Thoughts

The Oracle recruitment process is comprehensive, testing both technical skills and problem-solving ability. Successful candidates were evaluated on coding efficiency, understanding of fundamental concepts, and communication.


You may like these posts

Show more

advertisement