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. Python basics questions and programming questions
Add your answer
Q2. Write a program for Sum of natural numbers
Ans. 
Program to calculate the sum of natural numbers
• Use a loop to iterate through the natural numbers

• Keep adding each number to a running total

• Stop the loop when the desired number of natural numbers is reached

• Return the sum
Answered by AI
Add your answer
Q3. Write a program for primary numbers
Ans. 
Program to find prime numbers
• Start with a loop to iterate through numbers

• Check if each number is divisible by any number less than itself

• If not divisible, add it to the list of prime numbers
Answered by AI
Add your answer
Q4. What is decorator in python
Ans. 
A decorator in Python is a design pattern that allows a user to add new functionality to an existing object or function without modifying its structure.
• Decorators are denoted by the '@' symbol followed by the name of the decorator function.

• They are used to modify the behavior of functions or classes.

• Decorators can be used for logging, timing, caching, access control, etc.

• They provide a way to wrap or modify the behavio...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