Upload Button Icon Add office photos
Engaged Employer

i

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

Avekshaa Technologies Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Avekshaa Technologies Oracle Database Administrator Interview Questions and Answers

Updated 30 Oct 2024

Avekshaa Technologies Oracle Database Administrator Interview Experiences

1 interview found

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

I applied via Naukri.com and was interviewed in Sep 2024. There was 1 interview round.

Round 1 - Technical 

(3 Questions)

  • Q1. What is the default index type
  • Ans. 

    B-tree index is the default index type in Oracle database.

    • Default index type in Oracle is B-tree index

    • B-tree index is suitable for range queries and equality searches

    • Other index types in Oracle include bitmap index and function-based index

  • Answered by AI
  • Q2. What is the causes of query slowness
  • Ans. 

    Causes of query slowness can include inefficient queries, lack of indexes, outdated statistics, hardware limitations, and network latency.

    • Inefficient queries - poorly written queries that do not utilize indexes or join tables unnecessarily

    • Lack of indexes - missing indexes on columns frequently used in queries

    • Outdated statistics - outdated or inaccurate statistics can lead to poor query execution plans

    • Hardware limitatio...

  • Answered by AI
  • Q3. How to resolve query slowness
  • Ans. 

    To resolve query slowness, analyze query execution plan, optimize indexes, update statistics, consider partitioning.

    • Analyze query execution plan to identify bottlenecks

    • Optimize indexes to improve query performance

    • Update statistics to ensure the query optimizer has accurate information

    • Consider partitioning large tables to improve query performance

  • Answered by AI

Interview questions from similar companies

I applied via Campus Placement and was interviewed in Sep 2018. There were 5 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. Second round was f2f interview, he asked about c concepts, data structures pointers concepts , and final year projects concepts
  • Q2. HR round : He asked about introduction of me, and bond, and joining date

Interview Preparation Tips

Round: Test
Experience: First Round was technical aptitude which contains objective questions from c, c++, data structures java , difficulty ranging from medium to hard.

Duration: <1 week
College Name: S D M Institute Of Technology, Ujire
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Storage types, structures, padding
  • Q2. Bit operations in C language
  • Ans. 

    Bit operations in C language involve manipulating individual bits within a data structure.

    • Bitwise AND (&) - sets a bit to 1 only if both input bits are 1

    • Bitwise OR (|) - sets a bit to 1 if either input bit is 1

    • Bitwise XOR (^) - sets a bit to 1 if the input bits are different

    • Bitwise NOT (~) - inverts all bits in a number

    • Left shift (<<) - shifts bits to the left by a specified number of positions

    • Right shift (>>) - shifts

  • Answered by AI

Skills evaluated in this interview

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

I applied via Campus Placement and was interviewed in Dec 2024. There were 4 interview rounds.

Round 1 - Aptitude Test 

Arithmetic, verbal, and verbal skills.

Round 2 - Coding Test 

Please write a code for generating the Fibonacci sequence.

Round 3 - Technical 

(2 Questions)

  • Q1. What are the key features and concepts of the C programming language?
  • Ans. 

    C is a powerful and efficient programming language known for its low-level features and flexibility.

    • Key features include: low-level memory access, efficient manipulation of pointers, strong support for procedural programming, and a rich library of built-in functions.

    • Concepts include: data types, control structures (such as loops and conditionals), functions, arrays, and pointers.

    • Example: In C, you can directly access a...

  • Answered by AI
  • Q2. What is an array
  • Ans. 

    An array is a data structure that stores a collection of elements of the same type in a contiguous memory location.

    • Arrays have a fixed size determined at the time of declaration.

    • Elements in an array are accessed using an index starting from 0.

    • Example: string[] names = {"Alice", "Bob", "Charlie"};

  • Answered by AI
Round 4 - HR 

(1 Question)

  • Q1. When would you be able to join?
  • Ans. 

    I can start within 2 weeks of receiving an offer.

    • I can start within 2 weeks of receiving an offer.

    • I need to give notice to my current employer.

    • I may need time to relocate if necessary.

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare thoroughly when you are searching.

Interview Questionnaire 

3 Questions

  • Q1. 1. Assignment
  • Q2. 2. Bunch of python questions.
  • Q3. 3. coding questions.

Interview Preparation Tips

Interview preparation tips for other job seekers - Be clear with basics.
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Campus Placement and was interviewed in Apr 2024. There were 2 interview rounds.

Round 1 - Aptitude Test 

There are Question based on data strcuture ,they cover all the topic in ds

Round 2 - Coding Test 

In coding code they gave internet access to solve the problem after 30 they told us to make some changes in it and we should ready to explain the entire code

Interview Preparation Tips

Interview preparation tips for other job seekers - To clear 1 st round ,revise all the data structure concepts ,in second round make sure to be strong in fundamentals of programming and good in logical thinking
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

It was a Basic Aptitude Test

Round 2 - Coding Test 

We were asked to do Sorting, SQL queries (join)

Round 3 - HR 

(1 Question)

  • Q1. Can you tell me about yourself?
  • Ans. 

    I am a passionate software engineer with 5 years of experience in developing web applications using various technologies.

    • 5 years of experience in software development

    • Proficient in developing web applications

    • Skilled in using various technologies such as Java, JavaScript, and SQL

  • Answered by AI
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Referral and was interviewed before Jun 2022. There were 2 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Technical 

(3 Questions)

  • Q1. Linux commands,
  • Q2. Cloud technologies different services (iaas, paas, saas)
  • Ans. 

    Cloud technologies offer different services like IaaS, PaaS, and SaaS for varying levels of control and management.

    • IaaS (Infrastructure as a Service) provides virtualized computing resources over the internet, such as virtual servers and storage.

    • PaaS (Platform as a Service) offers a platform allowing customers to develop, run, and manage applications without dealing with infrastructure.

    • SaaS (Software as a Service) deli...

  • Answered by AI
  • Q3. What do you know AWS

Interview Preparation Tips

Interview preparation tips for other job seekers - Brush up OS basics and cloud technologies.

Skills evaluated in this interview

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Recruitment Consulltant and was interviewed before Apr 2023. There were 3 interview rounds.

Round 1 - Coding Test 

There was coding test

Round 2 - Technical 

(2 Questions)

  • Q1. 2 technical rounds
  • Q2. Merge sort algorithm
  • Ans. 

    Merge sort is a divide and conquer algorithm that divides the input array into two halves, sorts them separately, and then merges them back together in sorted order.

    • Divide the input array into two halves

    • Recursively sort each half

    • Merge the sorted halves back together

  • Answered by AI
Round 3 - Behavioral 

(1 Question)

  • Q1. Leetcode Easy question

Skills evaluated in this interview

I appeared for an interview before Jan 2021.

Interview Questionnaire 

2 Questions

  • Q1. Basic analysis questions
  • Q2. Excel Based analysis as it was a entry-level position

Interview Preparation Tips

Interview preparation tips for other job seekers - Read about the company
Read about the interviewer

Avekshaa Technologies Interview FAQs

How many rounds are there in Avekshaa Technologies Oracle Database Administrator interview?
Avekshaa Technologies interview process usually has 1 rounds. The most common rounds in the Avekshaa Technologies interview process are Technical.
How to prepare for Avekshaa Technologies Oracle Database Administrator 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 Avekshaa Technologies. The most common topics and skills that interviewers at Avekshaa Technologies expect are Performance Tuning, MS SQL Server, Oracle Database and Database Architecture.
What are the top questions asked in Avekshaa Technologies Oracle Database Administrator interview?

Some of the top questions asked at the Avekshaa Technologies Oracle Database Administrator interview -

  1. what is the causes of query slown...read more
  2. what is the default index t...read more
  3. how to resolve query slown...read more

Tell us how to improve this page.

Avekshaa Technologies Oracle Database Administrator Interview Process

based on 1 interview

Interview experience

5
  
Excellent
View more
Software Engineer
38 salaries
unlock blur

₹2.2 L/yr - ₹9 L/yr

Technical Specialist
34 salaries
unlock blur

₹6 L/yr - ₹13 L/yr

Senior Software Engineer
23 salaries
unlock blur

₹4.1 L/yr - ₹10.8 L/yr

Software Developer
11 salaries
unlock blur

₹10 L/yr - ₹14.3 L/yr

Senior Technical Specialist
10 salaries
unlock blur

₹11 L/yr - ₹24.8 L/yr

Explore more salaries
Compare Avekshaa Technologies with

Prime Focus Technologies

3.3
Compare

Yalamanchili Software Exports

3.3
Compare

ScoreMe Solutions

4.3
Compare

Algonomy

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