Oracle Interview Questions, Process, and Tips for Experienced

Basic DSA problem on BST

Problem solving on 3 sum array

Q1. HLD on online chat service
Add your answer
Q2. Design 1:1 chat first
Ans. 
Design a 1:1 chat feature for seamless communication between two users.
• Implement real-time messaging functionality

• Include features like read receipts, typing indicators, and message timestamps

• Allow users to share multimedia content such as images and videos

• Provide options for users to customize their chat settings and notifications
Answered by AI
Add your answer
Q3. Include media such as photo and video
Add your answer

Q1. Hiring manager round
Add your answer
Q2. Including behavioural question
Add your answer

Q1. Explain how an Select statement is parsed in Oracle database
Ans. 
The parsing of a SELECT statement in Oracle database involves several steps.
• The statement is first checked for syntax errors.

• The query is then parsed to identify the objects involved and their relationships.

• The optimizer determines the most efficient execution plan.

• The plan is executed and the result set is returned.
Answered by AI
Add your answer
Q2. Explain how an insert/update is parsed in Oracle database
Ans. 
An insert/update statement in Oracle database is parsed by the SQL parser to check syntax and semantics.
• The SQL parser first checks the syntax of the insert/update statement to ensure it follows the rules of the SQL language.

• Next, the parser checks the semantics of the statement, which involves verifying the existence and accessibility of the tables and columns referenced in the statement.

• During parsing, the parser als...read more
Answered by AI
Add your answer

Q1. How do access elements in XML/JSON data
Ans. 
To access elements in XML/JSON data, use appropriate methods like XPath for XML and dot notation for JSON.
• For XML data, use XPath expressions to navigate and extract specific elements or attributes.

• For JSON data, use dot notation to access nested objects or arrays.

• In PL/SQL, you can use XMLTable or JSON_TABLE functions to extract data from XML or JSON respectively.
Answered by AI
Add your answer
Q2. Explain different pragma objects
Ans. 
Pragma objects in PL/SQL provide compiler directives for controlling program behavior.
• Pragma AUTONOMOUS_TRANSACTION: Allows a subprogram to execute SQL statements independently of the calling program.

• Pragma EXCEPTION_INIT: Associates an exception name with an Oracle error number.

• Pragma INLINE: Suggests the compiler to inline the code of a subprogram at the call site.

• Pragma RESTRICT_REFERENCES: Specifies the purity leve...read more
Answered by AI
Add your answer

Q1. Where do you see yourself in 5 years from now
Add your answer

Questions were from cs subjects like os, dbms, oops, and some i/o related questions

2 dsa questions were asked of medium difficulty

Q1. Some dsa questions, 1 puzzle, oops related questions
Add your answer

Q1. This round was pretty informal compared to previous rounds as questions related to hobbies, and personal projects were asked.
Add your answer

Q1. Database normalization concepts
Add your answer
Q2. Java servlets and java oops concepts
Add your answer

Q1. Some hr related questions
Add your answer
Q2. Indept java questions and some logical outside of tech
Add your answer

Q1. Linux ,SQL and ds questions
Add your answer

Q1. Managerial round and technical questions
Add your answer