Oracle Member Technical Staff Interview Questions and Answers

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

Q1. Encoding strings gfg
Ans. 
Encoding strings involves converting data into a specific format for efficient storage or transmission.
• Encoding types: UTF-8, ASCII, Base64.

• Example: UTF-8 can represent any character in the Unicode standard.

• Base64 is often used for encoding binary data in text formats.

• ASCII is limited to 128 characters, suitable for basic English text.
Answered by AI
Add your answer
Q2. Merge two sorted linked lists - gfg
Ans. 
Merge two sorted linked lists into a single sorted linked list.
• Create a dummy node to simplify merging.

• Use two pointers to traverse both lists.

• Compare values of nodes from both lists.

• Append the smaller node to the merged list.

• Continue until one list is exhausted, then append the remainder of the other list.

• Example: List1: 1 -> 3 -> 5, List2: 2 -> 4 -> 6 results in: 1 -> 2 -> 3 -> 4 -> 5 -> 6.
Answered by AI
Add your answer

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...read more
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?
Ans. 
The SQL query identifies managers overseeing more than 10 employees using GROUP BY and HAVING clauses.
• Use GROUP BY: Aggregate employee records by manager ID to count employees per manager.

• HAVING Clause: Filter results to include only those managers with a count greater than 10.

• Example Query: SELECT manager_id FROM employees GROUP BY manager_id HAVING COUNT(employee_id) > 10;

• Join with Managers Table: To get manager d...read more
Answered by AI
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
Ans. 
Decoupling a monolith involves breaking it into smaller, independent services for better scalability and maintainability.
• Identify bounded contexts: Analyze the monolith to find distinct areas of functionality that can be separated.

• Use APIs for communication: Implement RESTful APIs or gRPC for services to interact without tight coupling.

• Adopt event-driven architecture: Utilize message brokers (e.g., RabbitMQ, Kafka) to ...read more
Answered by AI
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
Ans. 
Enhancing a company's database involves optimizing performance, ensuring data integrity, and improving user accessibility.
• Implement indexing on frequently queried columns to speed up search operations.

• Use normalization techniques to eliminate data redundancy and improve data integrity.

• Consider partitioning large tables to enhance performance and manageability.

• Implement caching strategies to reduce database load and imp...read more
Answered by AI
Add your answer
Q4. Java related questions
Add your answer
Q5. OOPS design patterns and importance
Add your answer