16 questions · from 1 interviews
Oracle Fusion interview questions
Every question candidates reported from their Oracle Fusion interviews, most frequently asked first. Each links to the write-up it came from, so you can see the round and how it went.
Oracle Fusion coding and DSA questions
- 01
Find Duplicates and Their Count in a Dataset
Given a dataset of numbers, find all duplicates and their respective counts. The interviewer asked to write either SQL queries or code. I chose to write code.
- 02
Find Nth Highest Salary
Find the Nth highest salary from a dataset. The interviewer asked to write either SQL queries or code. I chose to write code.
- 03
Combine Two Datasets with No Duplicates
Given two datasets, set1 and set2, combine them into a single dataset ensuring no duplicates. Write a SQL query or code for this.
- 04
Update Order Status Based on Line Item Status
Given two tables, Order and Lines , where one order can have multiple lines and both tables have a Status column. The task is to efficiently update the Order table's status to Closed only if all associated order line statuses are Closed . Write a SQL query or…
- 05
Top K Medal Winners (SQL)
Given the following dataset: 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 Write a SQL query to get the top K medal winners.
- 06
Top K Medal Winners with Dense Rank (SQL)
Follow-up to the 'Top K Medal Winners' problem: If two or more winners have the same number of medals, consider them as one rank. (Hint: Dense rank clause is the correct solution.)
Oracle Fusion system design questions
- 01
Handling Large Temporary Data for LLMs
Describe your approach when you need to send large temporary data to an LLM and perform a task on it.
- 02
Efficient Database Updates with Duplicates
Given a list of data that needs to be updated in the database, where the list can contain duplicates, describe an efficient approach to update the database.
- 03
Why Migrate to Kafka?
Explain the reasons or benefits for migrating to Kafka.
Oracle Fusion other questions
- 01
Node.js: import vs require
Explain the differences between import and require in Node.js.
- 02
Node.js Event Loop and Call Stack
Explain how the event call stack works in Node.js.
- 03
What are Vector Databases?
Explain what vector databases are.
- 04
How do Embeddings Work?
Explain how embeddings work.
- 05
How does Similarity Search Work?
Explain how similarity search works.
- 06
What is Circular Dependency?
Explain what circular dependency is.
- 07
Node.js Dependency Management: package.json vs package-lock.json
Explain how Node.js manages its dependencies, specifically comparing package.json and package-lock.json .
Oracle Fusion interview questions FAQ
What questions are asked in Oracle Fusion interviews?
Candidates reported 16 distinct questions across 1 Oracle Fusion interviews. 6 coding and DSA questions, 3 system design questions, 7 other questions.