Oracle Senior Technical Team Member Interview Questions and Answers

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

Good questions around data structures and algorithms

Good questions around data structures and algorithms

Good questions around datastructures and algorithms

Q1. Salesforce config
Add your answer
Q2. Lwc aura javascript databases sql
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

Simple aptitude question

Loops, basic binary search programme

Algorithm based coding round

Q1. Hard problem solved during project work
Add your answer
Q2. Most used technologies during work
Ans. 
The most used technologies during work include Java, Spring Boot, AWS, Docker, and Kubernetes.
• Java

• Spring Boot

• AWS

• Docker

• Kubernetes
Answered by AI
Add your answer

Q1. Tentative Date of joining
Ans. 
I am available to join within 2 weeks of receiving an offer.
• Available to join within 2 weeks of receiving offer

• Flexible with start date if needed

• Can start immediately if required
Answered by AI
Add your answer
Q2. Salary expectation
Add your answer

Q1. Merge sort, check duplicates
Add your answer
Q2. String related questions
Add your answer