Oracle Inteview Experience
- Result
- Ongoing
- Posted
- 11 Mar 2025
Summary
I recently had my first round interview with Oracle for a Software Engineer role in their ERP team, covering data structures, algorithms, Java concepts, SQL, and system design.
How it went
I recently had my first round (R1) interview for a Software Engineer (SE) role within the ERP team at Oracle. The interview covered a broad range of topics, including data structures and algorithms, core Java concepts, database queries, and system design principles. I was presented with several questions covering these areas during the round.
Questions asked (8)
- 01
Strings with Frequency Greater than Target
Data Structures & Algorithms · Medium
Given an array of strings, return all the strings whose frequency of occurrence in the array is greater than a specified target value.
- 02
Kth Largest Element
Data Structures & Algorithms · Medium
Find the Kth largest element in an unsorted array.
- 03
Sort List of Student Objects by Marks
Data Structures & Algorithms · Easy
Given a list of
Studentobjects, where each object has attributesName,RollNo, andmarks, write a function to print the list of objects sorted based on theirmarksin ascending order. - 04
Comparator vs. Comparable in Java
Other
Explain the difference between
ComparatorandComparableinterfaces in Java. Provide use cases for each. - 05
Internal Working of Static Variables in Java
Other
Explain what internally happens when a
staticvariable is used in Java, including its memory allocation and lifecycle. - 06
Department-wise Average Salary (SQL)
Other · Easy
Given two tables:
Employee(columns:EmpID,Name,DeptID,Salary) andDepartment(columns:DeptID,DeptName). Write an SQL query to find the average salary for each department. - 07
Experience with Design Patterns
System Design
Discuss the different design patterns you have worked on and describe your experience with them.
- 08
Monolithic vs. Microservices Architecture
System Design
Discuss the differences, advantages, and disadvantages of Monolithic versus Microservices architecture.