Questions that have appeared at Oracle for an Engineering (Case Study) interview.

1. System Architecture

Question: How would you design a system that needs to handle a high volume of transactions per second with low latency? What factors would you take into consideration?

Question: Describe a situation when you had to choose between a monolithic architecture and microservices. What factors influenced your decision?

Question: Can you explain how you would design a globally distributed database system? What are the challenges and how would you mitigate them?

2. Performance Optimization

Question: How would you troubleshoot a performance issue in a production system? What methods or tools would you use?

Question: Have you ever had to optimize a poorly performing system? What steps did you take and what was the outcome?

Question: Can you describe a situation where you needed to improve the performance of a database query? What approach did you take?

3. Scalability and Redundancy

Question: How would you design a system to be scalable during peak times, but cost-effective during off-peak times?

Question: Describe a situation when you had to design a redundant system. What was the need and how did you ensure redundancy?

Question: How would you approach the task of making an existing system more scalable? What factors would you consider?

4. Data Management

Question: How would you ensure the consistency of data across multiple databases in a distributed system?

Question: Can you explain how you would handle large amounts of data that needs to be processed and analyzed in real time?

Question: How would you approach the migration of large amounts of data from one database system to another, without causing downtime?

5. Project Management

Question: Describe a project where you had to manage time, resources, and scope to deliver on schedule. How did you ensure the project's success?

Question: Can you describe a situation where you had to make a trade-off between quality and timeline? How did you handle it?

Question: How would you manage a project that involves multiple teams with different priorities and deadlines?