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

1. Systems Design

Question: Imagine you are tasked with designing a large scale, distributed database system. What factors would you consider to ensure the system is robust, scalable, and efficient?

Question: How would you approach designing a real-time analytics platform that needs to handle large amounts of data from multiple sources?

Question: Can you describe what steps you would take to design a system for managing and processing large amounts of data in real-time?

2. Project Management

Question: Can you describe a time when you had to manage a complex engineering project? What were the challenges and how did you overcome them?

Question: Imagine you are leading a project that is behind schedule. What steps would you take to get the project back on track without compromising on quality?

Question: Can you discuss an example where you had to balance multiple project tasks with varying levels of urgency and importance? How did you prioritize?

3. Problem Solving

Question: Can you describe a time when you had to find a creative solution to a technical problem?

Question: Can you give an example of a difficult technical problem you solved and the process you used to solve it?

Question: You discover a major bug in a project close to its deadline. How do you handle this situation?

4. Architectural Decisions

Question: Can you describe a time when you had to make a significant architectural decision in a project? What factors did you consider and what was the outcome?

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

Question: What considerations would you make when selecting the appropriate data storage technology for a new application?

5. Collaboration and Teamwork

Question: Can you give an example of a time when you worked in a cross-functional team? How did you handle communication and collaboration?

Question: Can you describe a time when you disagreed with a team member on a technical issue? How was it resolved?

Question: How do you handle situations where you have to work with difficult team members or stakeholders?