Oracle Interview Questions, Process, and Tips for Freshers

Q1. Common Elements in two Sorted Linked List
Ans. 
Finding common elements in two sorted linked lists.
• Traverse both lists simultaneously using two pointers.

• Compare the values of the nodes pointed by the two pointers.

• If they are equal, add the value to the result list and move both pointers.

• If not, move the pointer pointing to the smaller value.

• Repeat until one of the lists is fully traversed.
Answered by AI
Add your answer
Q2. Kth element after merging two sorted arrays
Ans. 
Finding the Kth element after merging two sorted arrays.
• Merge the two sorted arrays into a single array.

• Sort the merged array.

• Return the Kth element from the merged and sorted array.
Answered by AI
Add your answer
Q3. A good amount of OOPS?DBMS questions, small keywords used in project, data flow in projects were asked
Add your answer

Q1. Detailed concepts about OOPS and DBMS
Ans. 
OOPS is a programming paradigm based on objects while DBMS is a software system for managing databases.
• OOPS focuses on encapsulation, inheritance, and polymorphism

• DBMS manages data through CRUD operations and supports ACID properties

• Examples of OOPS languages include Java, C++, and Python

• Examples of DBMS include MySQL, Oracle, and SQL Server
Answered by AI
Add your answer
Q2. Detailed study and questions about project.
Add your answer

Q1. Knowledge about latest technologies
Add your answer
Q2. Why they should hire me?
Add your answer
Q3. Why oracle? followed by questions from computer networks, OOPS, DBMS and a bit from major CS fundamentals.
Add your answer

Basic math problems and English related questions

Write a program to give out the final score in a cricket match where number of deliveries will be the input and in a ball a batsman ca score either 1,0 or 2.

Q1. Write a program to separate strong for special characters
Ans. 
Program to separate strong for special characters in an array of strings
• Iterate through each string in the array

• For each string, iterate through each character

• Check if the character is a special character and separate it into a new string if it is
Answered by AI
Add your answer
Q2. General question about personal projects
Add your answer

Q1. Questions about OOPs concept
Add your answer
Q2. What is Function overloading and overriding?
Ans. 
Function overloading is having multiple functions with the same name but different parameters. Function overriding is redefining a function in a subclass.
• Function overloading allows multiple functions with the same name but different parameters.

• Function overriding involves redefining a function in a subclass with the same name and parameters as in the superclass.

• Example of function overloading: int add(int a, int b) an...read more
Answered by AI
Add your answer

Q1. General question on extra activities in the resume
Add your answer

Q1. What is data warehousing
Ans. 
Data warehousing is the process of collecting, storing, and managing data from various sources for analysis and reporting.
• Data warehousing involves extracting data from multiple sources

• Data is transformed and loaded into a central repository

• Data can be queried and analyzed for business intelligence purposes

• Examples include data warehouses like Amazon Redshift, Snowflake, and Google BigQuery
Answered by AI
Add your answer

3 coding question and 15 other mcc type question to solve in 3 hours

Q1. Introduction about myself and talk on project
Add your answer
Q2. Asked me to code in whichever language I preferred
Add your answer

Q1. This was second round Here I was asked to code it was the question of DAA and asked further to optimise it
Add your answer

The test was largely abstract. These were very different logical questions related to SQLs, data structures, core Java concepts, Threads, and more.

Q1. What is Polymorphism?
Ans. 
Polymorphism is the ability of an object to take on many forms.
• Polymorphism allows objects of different classes to be treated as objects of a common superclass.

• It enables methods to be overridden in a subclass to provide different implementations.

• Polymorphism enhances code reusability and flexibility.

• Example: A superclass 'Animal' with subclasses 'Dog' and 'Cat' can be treated as 'Animal' objects.

• Example: Method 'draw(...read more
Answered by AI
Add your answer
Q2. What is Abstraction?
Ans. 
Abstraction is the process of simplifying complex systems by focusing on the essential details.
• Abstraction involves hiding unnecessary details and exposing only the relevant information.

• It allows us to create models or representations that capture the essential characteristics of a system.

• Abstraction helps in managing complexity and improving understanding and communication.

• Examples of abstraction include using functio...read more
Answered by AI
Add your answer

Q1. What projects have you worked on in the past?
Add your answer
Q2. What was the most challenging project?
Add your answer
Q3. Why was it challenging and how did you approach it?
Add your answer

10 Questions from core subjects such as OS DBMS OOPS and CN and 2 questions for integrating APIs with and returning required data in any language. Platform: Hackerrank

2 coding questions:
1. Find the missing number in an array
2. LRU Cache
Solved the above two in 20 minutes. This was followed by questions related to my projects which included questions related to MERN stack, WebRTC, Sockets, etc.

2 coding questions:
1. Bitwise DP
2. Follow up (didn’t have to solve this one just approach was fine)

Followed by some questions from SQL

Q1. Why do you want to join Oracle? Why are you not going for higher studies and why do you prefer to work now? Where do you see yourself in the next 5 years? Some DBMS concepts like normalisation, ACID proper...read more
Add your answer