Oracle Interview Questions, Process, and Tips for Experienced

Q1. Sort the array of 0,1,2
Ans. 
Sort an array of strings containing '0', '1', and '2'.
• Use counting sort algorithm to count the occurrences of '0', '1', and '2'.

• Create a new array based on the counts of each element.

• Return the sorted array.
Answered by AI
Add your answer
Q2. All c++ core concepts and oops concept. Find second greatest element in an array without sorting.
Ans. 
Find the second greatest element in an array without sorting using C++ concepts.
• Iterate through the array to find the greatest element.

• While iterating, keep track of the second greatest element.

• Return the second greatest element once the iteration is complete.
Answered by AI
Add your answer

Q1. Design quick ecommerce site.
Ans. 
Designing a quick ecommerce site involves creating a user-friendly interface with easy navigation and secure payment options.
• Focus on a clean and intuitive user interface

• Implement a robust search functionality for products

• Include secure payment gateways like PayPal or Stripe

• Optimize site speed for quick loading times

• Ensure mobile responsiveness for on-the-go shopping

• Integrate customer reviews and ratings for trust-buil...read more
Answered by AI
Add your answer
Q2. Consumer producer multithreading program.
Ans. 
Consumer producer multithreading program involves multiple threads sharing a common buffer to produce and consume data.
• Use synchronized data structures like BlockingQueue to handle thread synchronization.

• Implement separate producer and consumer classes with run methods.

• Use wait() and notify() methods to control the flow of data between producer and consumer threads.
Answered by AI
Add your answer
Q3. Find missing and repeating element in an array of 1 to n elements. N is the size of array. Solve in O-n time and O-1 space.
Ans. 
Find missing and repeating element in an array of 1 to n elements in O(n) time and O(1) space.
• Iterate through the array and for each element, mark the element at index equal to its value as negative. If the element is already negative, it is the repeating element.

• After marking all elements, the positive element's index + 1 is the missing element.

• Example: Array ['1', '2', '3', '3', '5'] - Repeating element is '3' and mi
Answered by AI
Add your answer

Q1. What is expected compensation
Ans. 
Expected compensation should be based on industry standards, experience, skills, and location.
• Research industry standards for Senior Software Engineer salaries

• Consider your level of experience and skills

• Take into account the cost of living in the location of the job

• Negotiate based on your value to the company
Answered by AI
Add your answer

Q1. Java concepts based on streams and oops concepts and singleton class
Add your answer
Q2. DSA questions like first missing number and rotate array
Add your answer

Q1. SQL queries based on group by and implementation of min heap
Add your answer
Q2. Scenario based question like what data structure are used
Add your answer

Q1. Java based questions like difference between interface and abstract class and spring boot rest API implementation
Add your answer
Q2. Permutation of the number without duplicates
Ans. 
Generate all permutations of a given number without duplicates
• Use backtracking to generate all possible permutations

• Avoid duplicates by keeping track of used digits

• Recursively swap digits to generate permutations
Answered by AI
Add your answer

Design an circular linked list

Went through the previous projects and asked some design question

Q1. Past Experience, Salary expectation, skills
Add your answer

Q1. Questions on previous project and role, Technical Question 5- 6
Add your answer
Q2. How can You optimize MySQL queries.
Ans. 
Optimizing MySQL queries involves using indexes, avoiding unnecessary joins, optimizing data types, and using query caching.
• Use indexes on columns frequently used in WHERE, ORDER BY, and GROUP BY clauses.

• Avoid using SELECT * and only fetch the columns needed.

• Optimize data types to use the smallest data type possible for each column.

• Avoid unnecessary joins and use INNER JOIN instead of OUTER JOIN when possible.

• Enable qu...read more
Answered by AI
Add your answer

Q1. Managerial Questions
Add your answer
Q2. Why want to leave the previous company
Add your answer

Codility test. Data structure and algos

Q1. Greedy algrithm
Add your answer
Q2. Sorting an array
Ans. 
Sorting an array of strings
• Use built-in sorting functions like sort() in most programming languages

• Consider the case sensitivity of the strings when sorting

• You can customize the sorting order by providing a comparison function
Answered by AI
Add your answer