Oracle Technical Analyst Interview Questions and Answers

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

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

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. Difference between custom Metadata and custom settings
Ans. 
Custom metadata is customizable, deployable, and upgradeable application metadata, while custom settings are application settings that can be accessed using Apex code.
• Custom metadata is deployable and upgradeable, while custom settings are not

• Custom metadata is customizable at the field level, while custom settings are not

• Custom metadata can be accessed in Apex using SOQL queries, while custom settings can be accessed
Answered by AI
Add your answer
Q2. Basic implementation questions
Add your answer

Q1. Tell about your most challenging task
Add your answer
Q2. Can we call Aura from LWC
Ans. 
Yes, Aura can be called from LWC using the lightning namespace
• Aura can be called from LWC using the 'lightning' namespace

• You can use 'lightning/navigation' to navigate to a record page or URL

• You can also use 'lightning/messageService' to communicate between components
Answered by AI
Add your answer

Q1. Scenario based questions
Add your answer
Q2. Previous project related que
Add your answer
Q3. Asset and workflow related que
Add your answer

Q1. Asset or wf que
Add your answer
Q2. Sling resolver case scenario
Ans. 
Sling resolver case scenario involves resolving resource paths in Apache Sling.
• Understand how Sling resolves resource paths based on the request URL

• Know how Sling uses ResourceResolver to map URLs to resources

• Be familiar with Sling's resource resolution algorithm
Answered by AI
Add your answer

Q1. Basic info about myself and profile
Add your answer
Q2. Expectations about salary
Ans. 
Salary expectations should be based on industry standards, experience, and qualifications.
• Research industry standards for the position

• Consider your level of experience and qualifications

• Be prepared to negotiate based on the job responsibilities and benefits offered
Answered by AI
Add your answer