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

1. System Design

Question: How would you design a system for a global company that needs to handle millions of users concurrently?

Question: Can you explain how you would design a system to process a large stream of real-time data?

Question: How would you design a distributed database system for a company that prioritizes data consistency?

2. Scalability

Question: Imagine you've built a web application that suddenly experiences a significant increase in traffic. How would you ensure it scales effectively?

Question: Can you discuss a time when you had to scale a system or application to meet growing demand?

Question: How would you approach improving the performance of a slow but critical service in a software system?

3. Fault Tolerance & Recovery

Question: How would you design a system that can handle and recover from system failures effectively?

Question: Can you describe a time when you had to manage a system failure? How did you handle it and what did you learn from it?

Question: How would you approach building a fault-tolerant system for a mission-critical application?

4. Data Management

Question: Can you explain how you would design a data pipeline for a large company?

Question: How would you handle data migration from one system to another?

Question: How would you design a system to ensure data integrity and security?

5. Software Architecture

Question: How would you structure a large-scale software project and why?

Question: Can you discuss a time when you had to make a critical architectural decision in a project?

Question: How would you decide between using a microservices architecture versus a monolithic architecture for a new project?