I applied through an employee referral. I interviewed at Oracle (Redwood Shores, CA) in Nov 2023
Interview
Phone screen, followed by a technical interview conducted by a junior engineer, followed by a technical and behavioral interview with the manager of the team. I asked the recruiter if they needed anything else, and the manager had more he wanted to ask, so I did an additional follow-up interview with him that was about 30 minutes.
Interview questions [3]
Question 1
The first interview was basically just Degree of Array (LeetCode 697) and a lot of general knowledge questions about programming and Java (what is encapsulation, what is a class, what is inheritance, etc.). The former was through an online interview, live-coding software (don't recall which one), and the latter was verbal.
Design a relational database for a school. They also asked me to think of SQL queries that might be used to fetch certain data based on my design. I didn't have to write them down, just verbalise them. We did this on a Zoom whiteboard.
How would you upload a large file to a database? Write pseudocode for the insertion script. We did this in my local code editor, with me sharing the screen.