Oracle Inteview Experience
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.
Full Experience
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.
Interview Questions (8)
Strings with Frequency Greater than Target
Given an array of strings, return all the strings whose frequency of occurrence in the array is greater than a specified target value.
Kth Largest Element
Find the Kth largest element in an unsorted array.
Sort List of Student Objects by Marks
Given a list of Student objects, where each object has attributes Name, RollNo, and marks, write a function to print the list of objects sorted based on their marks in ascending order.
Comparator vs. Comparable in Java
Explain the difference between Comparator and Comparable interfaces in Java. Provide use cases for each.
Internal Working of Static Variables in Java
Explain what internally happens when a static variable is used in Java, including its memory allocation and lifecycle.
Department-wise Average Salary (SQL)
Given two tables: Employee (columns: EmpID, Name, DeptID, Salary) and Department (columns: DeptID, DeptName). Write an SQL query to find the average salary for each department.
Experience with Design Patterns
Discuss the different design patterns you have worked on and describe your experience with them.
Monolithic vs. Microservices Architecture
Discuss the differences, advantages, and disadvantages of Monolithic versus Microservices architecture.