Oracle Interview Questions, Process, and Tips for Experienced

Q1. Invoice creation
Add your answer
Q2. P2P Cycle explanation
Ans. 
P2P cycle involves the process of procuring goods or services from a supplier.
• P2P stands for Procure to Pay cycle

• It includes steps like requisition, purchase order, goods receipt, invoice receipt, and payment

• Ensures proper controls and compliance with company policies

• Integration with suppliers and financial systems is crucial
Answered by AI
Add your answer

Q1. Rac gg asm dg rman performance tunning
Add your answer

Q1. Rac, asm, dg, rman, GG,
Add your answer

Q1. Technical and behaviour
Add your answer

Q1. Technical and behaviour and confirmation to commitment to Oracle.
Add your answer

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

Q1. Asked about the internal implementation of hashmap, arraylist etc. and asked questions about design patterns
Add your answer
Q2. Questions were specifically on Java, collections, streams, multithreading etc.
Add your answer

Design an circular linked list

Went through the previous projects and asked some design question