Oracle Principal Technical Staff Member Interview Questions and Answers

Q1. It was ML system design where they asked me to design Quora
Add your answer
Q2. Code Kmeans from scratch
Add your answer

Q1. Quick sorting is asked in this round
Add your answer
Q2. Tree traversal was asked
Add your answer

Q1. Merge sort was asked
Add your answer
Q2. Binary search was asked
Add your answer

Code snippets apti to guess output

5 questions with each 15 min time

Long coding with 2 hrs time

Q1. Db modelling for accounting app
Ans. 
Database modeling for an accounting application
• Identify entities such as customers, invoices, transactions, and accounts

• Establish relationships between entities (e.g. one-to-many, many-to-many)

• Consider normalization to reduce redundancy and improve data integrity

• Use primary keys and foreign keys to maintain data consistency

• Implement constraints to enforce business rules (e.g. unique constraints, check constraints)
Answered by AI
Add your answer
Q2. Class diagram and system design for any fintech app
Ans. 
A fintech app class diagram and system design involves modeling classes, relationships, and interactions for financial services.
• Identify key classes such as User, Account, Transaction, and Payment

• Define relationships between classes (e.g. User has many Accounts, Account has many Transactions)

• Consider security measures for sensitive financial data

• Include features like authentication, authorization, and encryption

• Design ...read more
Answered by AI
Add your answer

Q1. Design parking lot
Ans. 
Design a parking lot with efficient layout and features
• Consider the size and layout of the parking lot

• Include designated spots for different types of vehicles (compact, regular, handicapped)

• Implement a clear signage system for easy navigation

• Incorporate security measures such as lighting and surveillance cameras

• Include payment options for parking fees (e.g. ticket machines, mobile app)

• Consider environmental factors lik
Answered by AI
Add your answer

Simple aptitude question

Loops, basic binary search programme