Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by Oracle Team. If you also belong to the team, you can get access from here

Oracle Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Oracle Technical Analyst Interview Questions and Answers

Updated 6 May 2024

Oracle Technical Analyst Interview Experiences

3 interviews found

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Company Website and was interviewed in Mar 2024. There were 3 interview rounds.

Round 1 - HR 

(1 Question)

  • Q1. Past Experience, Salary expectation, skills
Round 2 - Technical 

(2 Questions)

  • Q1. Questions on previous project and role, Technical Question 5- 6
  • Q2. How can You optimize MySQL queries.
  • Ans. 

    Optimizing MySQL queries involves using indexes, avoiding unnecessary joins, optimizing data types, and using query caching.

    • Use indexes on columns frequently used in WHERE, ORDER BY, and GROUP BY clauses.

    • Avoid using SELECT * and only fetch the columns needed.

    • Optimize data types to use the smallest data type possible for each column.

    • Avoid unnecessary joins and use INNER JOIN instead of OUTER JOIN when possible.

    • Enable qu...

  • Answered by AI
Round 3 - One-on-one 

(2 Questions)

  • Q1. Managerial Questions
  • Q2. Why want to leave the previous company

Interview Preparation Tips

Topics to prepare for Oracle Technical Analyst interview:
  • Html5
  • Java
  • Python
  • MySQL
Interview preparation tips for other job seekers - Prepare according to Job description and resume.

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Approached by Company and was interviewed before May 2023. There were 2 interview rounds.

Round 1 - Coding Test 

Search an unsorted array

Round 2 - Technical 

(1 Question)

  • Q1. Create dumic website
  • Ans. 

    Creating a dummy website involves designing and developing a basic website for testing purposes.

    • Choose a simple layout and design for the website

    • Include placeholder content and images

    • Ensure basic functionality like navigation and links work

    • Use dummy data for testing purposes

    • Consider using a website builder or coding from scratch

  • Answered by AI

Skills evaluated in this interview

Technical Analyst Interview Questions Asked at Other Companies

asked in Coforge
Q1. Write a program to get a employee list whose salary is greater th ... read more
Q2. Optimize the code for job scheduling written in the first round
asked in Coforge
Q3. Explain Security authentication implementation and what are the d ... read more
asked in Coforge
Q4. How did you implemented the microservices in your project, What a ... read more
asked in Coforge
Q5. How did you configure Api gateway to manage your microservices?

Interview Questionnaire 

3 Questions

  • Q1. About past experience and how could you benefit present company from past experience ?
  • Q2. What do you know about Oracle? Why do you want to join us ?
  • Q3. Achievements, difficulties, feedbacks from past organization?

Technical Analyst Jobs at Oracle

View all

Interview questions from similar companies

Consultant Interview Questions & Answers

Adobe user image harish sridharan

posted on 16 Mar 2024

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Not Selected

I applied via Campus Placement and was interviewed in Feb 2024. There were 3 interview rounds.

Round 1 - Aptitude Test 

Focus on all basic aptitude concepts

Round 2 - Technical 

(1 Question)

  • Q1. Stack parenthesis
Round 3 - HR 

(1 Question)

  • Q1. Have you attended hackerrank
  • Ans. 

    Yes, I have attended Hackerrank for coding challenges and practice.

    • I have completed coding challenges on Hackerrank to practice my skills

    • I have participated in coding competitions on Hackerrank

    • I have used Hackerrank to prepare for technical interviews

  • Answered by AI

I applied via Recruitment Consultant and was interviewed in Mar 2021. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Tell me something about yourselyoir roles and responsibilities in the last company Current job applied job description Why u left your last company Movie you recently watched About your last company Y...

Interview Preparation Tips

Interview preparation tips for other job seekers - Interview went for 15-20 mins
There rounds of interview (hr, v&a, ops). It depends upon process to process. In some process they might not go for v&a
Interview experience
3
Average
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed before Mar 2023. There were 3 interview rounds.

Round 1 - Coding Test 

Basic coding questions

Round 2 - Coding Test 

Advance Coding Questions related to SpringBoot, Microservice design patterns

Round 3 - HR 

(1 Question)

  • Q1. Basic HR Questions and salary discussion
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via LinkedIn and was interviewed in Apr 2024. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. Implement custom reduce function in js
  • Ans. 

    Custom reduce function in JavaScript

    • Create a function that takes an array, a callback function, and an initial value as parameters

    • Iterate through the array and apply the callback function to each element, updating the accumulator

    • Return the final accumulator value

  • Answered by AI
  • Q2. Box sizing in css
  • Ans. 

    Box sizing in CSS determines how the total width and height of an element is calculated.

    • Box-sizing property can have values of content-box (default) or border-box

    • content-box includes only the content, border, and padding in the width and height calculations

    • border-box includes the content, padding, and border in the width and height calculations

  • Answered by AI

Interview Preparation Tips

Topics to prepare for Automatic Data Processing (ADP) Consultant interview:
  • Javascript
  • Angular

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Job Portal and was interviewed before Oct 2023. There was 1 interview round.

Round 1 - One-on-one 

(2 Questions)

  • Q1. Design book my show
  • Q2. Implement Binary First Search
  • Ans. 

    Binary First Search is a search algorithm that explores the nodes in a binary tree in a level-order traversal.

    • Start at the root node and add it to a queue.

    • While the queue is not empty, dequeue a node and visit it. Then enqueue its children.

    • Repeat until all nodes have been visited.

  • Answered by AI

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. .net full stack
Round 2 - HR 

(1 Question)

  • Q1. Why do you want to change
Interview experience
1
Bad
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

These are some tests they have copied from other organizations.

Interview Preparation Tips

Interview preparation tips for other job seekers - If you love yourself and your peace of mind don't even think of joining this toxic place. Specially the design team. There is a monopoly of one not so gentle gentleman. Here's a list of tasks in his daily routine:

Schedule one on ones so he can start the day by shouting at people.

Belittling

Humiliating

Crushing people's confidence

Every year, he goes on a rampage so he can replace his entire team.This is a routine toxic practice he religiously follows regardless of the work that you do.

He has a step by plan, follows the exact same script regardless of what you do and don't do. For example, a co-worker who has a MA in linguistics was told to improve her English. This is hilarious and ironic at the same time. Another Co worker who has trained at least 15000 associates across locations in the last 2 decades. And suddenly the organization realizes that she missed a full stop. And she gets fired for a full stop, a comma and a colon.
Ridiculous, horrible, pathetic are just a few small words for this place. MY SERIOUS ADVISE, DON'T JOIN. SIT AT HOME BUT NEVER JOIN ADP.

Oracle Interview FAQs

How many rounds are there in Oracle Technical Analyst interview?
Oracle interview process usually has 2-3 rounds. The most common rounds in the Oracle interview process are Technical, HR and One-on-one Round.
How to prepare for Oracle Technical Analyst interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Oracle. The most common topics and skills that interviewers at Oracle expect are Troubleshooting, Oracle, SQL, PLSQL and Support Services.
What are the top questions asked in Oracle Technical Analyst interview?

Some of the top questions asked at the Oracle Technical Analyst interview -

  1. How can You optimize MySQL queri...read more
  2. Create dumic webs...read more

Tell us how to improve this page.

Oracle Technical Analyst Interview Process

based on 2 interviews

Interview experience

4
  
Good
View more

Interview Questions from Similar Companies

Google Interview Questions
4.4
 • 840 Interviews
Amdocs Interview Questions
3.7
 • 516 Interviews
Zoho Interview Questions
4.3
 • 512 Interviews
SAP Interview Questions
4.2
 • 283 Interviews
Adobe Interview Questions
3.9
 • 234 Interviews
Salesforce Interview Questions
4.0
 • 228 Interviews
24/7 Customer Interview Questions
3.5
 • 176 Interviews
View all
Oracle Technical Analyst Salary
based on 235 salaries
₹4.7 L/yr - ₹15.3 L/yr
8% less than the average Technical Analyst Salary in India
View more details

Oracle Technical Analyst Reviews and Ratings

based on 27 reviews

4.0/5

Rating in categories

3.2

Skill development

4.1

Work-life balance

3.5

Salary

4.1

Job security

4.1

Company culture

2.8

Promotions

3.2

Work satisfaction

Explore 27 Reviews and Ratings
Technical Analyst 3-Support

Bangalore / Bengaluru

5-8 Yrs

Not Disclosed

Technical Analyst 3-Support

Bangalore / Bengaluru

6-8 Yrs

Not Disclosed

Technical Analyst 3-Support

Bangalore / Bengaluru

6-8 Yrs

Not Disclosed

Explore more jobs
Senior Software Engineer
2.5k salaries
unlock blur

₹10.3 L/yr - ₹40 L/yr

Principal Consultant
2.1k salaries
unlock blur

₹10.9 L/yr - ₹37 L/yr

Senior Consultant
2.1k salaries
unlock blur

₹9.1 L/yr - ₹25 L/yr

Senior Member of Technical Staff
1.8k salaries
unlock blur

₹13.5 L/yr - ₹45 L/yr

Senior Application Engineer
1.4k salaries
unlock blur

₹9.7 L/yr - ₹30 L/yr

Explore more salaries
Compare Oracle with

SAP

4.2
Compare

MongoDB

3.8
Compare

Salesforce

4.0
Compare

IBM

4.0
Compare
Did you find this page helpful?
Yes No
write
Share an Interview