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)
Given an array of strings, return all the strings whose frequency of occurrence in the array is greater than a specified target value.
Find the Kth largest element in an unsorted array.
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.
Explain the difference between Comparator and Comparable interfaces in Java. Provide use cases for each.
Explain what internally happens when a static variable is used in Java, including its memory allocation and lifecycle.
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.
Discuss the different design patterns you have worked on and describe your experience with them.
Discuss the differences, advantages, and disadvantages of Monolithic versus Microservices architecture.