Oracle Member Technical Staff Interview Questions, Process, and Tips

Leetcode medium problems

Q1. System design questions
Add your answer

This round was a culture fit round

Q1. Asasdasd asdasdas asdasda dasdas
Add your answer
Q2. Asdasdasd sdasdasda asdasda asdad
Add your answer

Q1. Question 1(Medium)
Add your answer
Q2. Question 2(medium)
Add your answer

DSA, java, previous projects

2 leetcode medium questions

The 90-minute assessment consists of approximately 45 questions covering Java, SQL, Linux, flowchart-based questions, and one coding question.

Q1. How can you detect a loop in a linked list?
Ans. 
Detecting a loop in a linked list can be efficiently done using Floyd's Cycle-Finding Algorithm.
• Use two pointers: slow and fast. Initialize both at the head of the list.

• Move slow pointer one step at a time and fast pointer two steps at a time.

• If there is a loop, the fast pointer will eventually meet the slow pointer.

• If the fast pointer reaches the end of the list (null), there is no loop.

• Example: In a list 1 -> 2 -&...read more
Answered by AI
Add your answer
Q2. Is it possible to move the fast pointer by an increment other than two nodes at a time while applying the slow and fast pointer approach?
Ans. 
Yes, the fast pointer can move by different increments in the slow and fast pointer technique.
• The slow and fast pointer technique is often used to detect cycles in linked lists.

• If the fast pointer moves by 1 node instead of 2, it can still be effective for certain problems.

• For example, moving the fast pointer by 3 nodes can help find the middle of a list in a different way.

• Adjusting the increment can change the algorit
Answered by AI
Add your answer

Q1. Some DBMS and OS question and project discussion
Add your answer
Q2. What is thrashing in operating systems (OS)?
Ans. 
Thrashing occurs when an OS spends more time swapping pages in and out of memory than executing processes.
• Thrashing happens when there is insufficient physical memory to hold all active processes.

• It leads to a significant decrease in system performance due to excessive paging.

• Example: A system running multiple memory-intensive applications may thrash if RAM is insufficient.

• To mitigate thrashing, the OS may implement pa...read more
Answered by AI
Add your answer

Q1. It was technical+ HR around
Add your answer
Q2. Where do you envision yourself in five years?
Ans. 
In five years, I see myself as a lead engineer, driving innovative projects and mentoring junior staff in a collaborative environment.
• Leading a team on cutting-edge projects, such as developing scalable cloud solutions.

• Mentoring junior engineers, helping them grow their skills and advance their careers.

• Contributing to open-source projects to enhance my technical expertise and community involvement.

• Pursuing advanced cer...read more
Answered by AI
Add your answer
Q3. What is the SQL query to find the manager who is managing more than 10 employees?
Add your answer

Q1. How do you convert a web application to mobile app and how do you scale it.
Add your answer
Q2. How to decouple monolith service and how they interact
Add your answer
Q3. Projects in resume
Add your answer
Q4. API's related basic questions
Add your answer

Q1. Pointers related questions in C
Add your answer
Q2. Linked lists questions, loop detection, loop correction
Add your answer
Q3. OS related calls, like system calls
Add your answer

Q1. Database questions like what is database, indexing, sharding, etc
Add your answer
Q2. How to manage memory in databases, how to convert sample data to relational data
Add your answer
Q3. Gave an example company scenario and asked how to improve their database based on the requirements
Add your answer
Q4. Java related questions
Add your answer
Q5. OOPS design patterns and importance
Add your answer