Oracle Fusion Interview Experience | IC3 | Selected

Round 1

1. We have a dataset of numbers. Find duplicates and their count.
2. Find the Nth highest salary.
3. import vs require(Node.js)
4. How does the event call stack work in Node.js?

For questions 1 and 2, I was asked to write either SQL queries or code. I chose to write code.

Round 2

1. Questions based on my resume, such as what I used in my projects.
2. Checked my working experience with AI.
   1. Questions on what I built using AI.
3. Deep dive into RAG.
   1. What are vector databases?
   2. How do embeddings work?
   3. How does similarity search work?
4. When you need to send large temporary data to an LLM and perform a task on it, what would be your approach?
5. Two datasets – set1 and set2. Combine them into one dataset with no duplicates. Write a SQL query or code.
6. We have a list of data that needs to be updated in the database. The list can contain duplicates. How will you efficiently update your database?Answer: Caching (keep a HashSet; once an update is done, check the HashSet to see if it is already updated. This reduces database calls).

Round 3

1. Explain any recent project.
   1. Question on why we migrated to Kafka.
2. Two tables – Order and Lines.
   One order can have multiple lines.
   Both tables have a column called Status.
   You need to update the Order table status to Closed only if all order line statuses are Closed, efficiently.
   Write a Sql query or code. I wrote code.
3. Write a Sql query

   Name  SportName    Medal
   A     Cricket      Gold
   A     Football     Silver
   B     Football     Gold
   C     Basketball   Gold
   D     Tennis       Gold
   E     Cricket      Silver
   F     Football     Silver
   B     Basketball   Silver
   G     Tennis       Silver
   

   1. Get the top K medal winners.
   2. Follow-up: If two or more have the same number of medals, consider them as one. (Dense rank clause is the correct solution.)
4. A similar question about two people booking the same seat (concurrency concept).
5. What is circular dependency?
6. How does Node.js manage its dependencies? package.json vs package-lock.json.

Additional Details

• All 3 rounds were virtual.
• Job role: Java + AI.
• I took a referral from a friend. Since I am not a Java developer, they asked me Node.js questions instead.
• All 3 rounds went well. I answered most of the questions. I felt Round 2 went very well compared to the other two.

Round 4 (In-person)

• Fit check type questions. Not a technical round.
• Salary discussion