Premium Employer

i

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

Clover Infotech Verified Tick

Compare button icon Compare button icon Compare
3.6

based on 1.1k Reviews

Filter interviews by

Clover Infotech Senior Oracle Database Administrator Interview Questions and Answers

Updated 15 Aug 2023

Clover Infotech Senior Oracle Database Administrator Interview Experiences

1 interview found

Senior Oracle Database Administrator Interview Questions & Answers

user image Muhammad Azhar Akbar Khan

posted on 15 Aug 2023

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

I applied via Walk-in and was interviewed in Jul 2023. There were 3 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 - Aptitude Test 

1st Aptitude test
2nd one to one Round
3rd HR

Round 3 - One-on-one 

(2 Questions)

  • Q1. Senior person taking 2nd round
  • Q2. Depand on profile likeOracle sql

Interview Preparation Tips

Interview preparation tips for other job seekers - My self and Salary descision

Interview questions from similar companies

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

I applied via Referral and was interviewed in Feb 2024. There were 2 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. DBA related questions
  • Q2. Golden Gate architecture, RAC, Data guard
Round 2 - Technical 

(2 Questions)

  • Q1. Partition tables
  • Q2. RAC-startup, export/import
Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Describe your daily activity
  • Q2. Errors you have faced

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via campus placement at St Francis Institute of Technology, Mumbai and was interviewed in Apr 2023. There were 5 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 - Aptitude Test 

Basic Apptitude. SQL & logic in

Round 3 - Group Discussion 

Very easy topic. You just need to have fluent English.

Round 4 - Group Discussion 

They took two GD as many people were selected

Round 5 - One-on-one 

(1 Question)

  • Q1. They asked basic and advanced SQL queries

Interview Preparation Tips

Topics to prepare for Mastek SQL Database Administrator interview:
  • SQL
  • Logic
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Referral and was interviewed before Sep 2023. There was 1 interview round.

Round 1 - One-on-one 

(4 Questions)

  • Q1. What is database?
  • Ans. 

    A database is a structured collection of data that is organized in a way that allows for easy access, management, and retrieval.

    • A database is used to store and organize data in a structured format.

    • It allows for efficient retrieval and manipulation of data.

    • Examples of databases include MySQL, Oracle, SQL Server, and MongoDB.

  • Answered by AI
  • Q2. What is MySQL? why it is popular?
  • Ans. 

    MySQL is an open-source relational database management system that is popular for its ease of use, flexibility, and scalability.

    • MySQL is an open-source RDBMS, allowing users to freely use, modify, and distribute the software.

    • It is known for its ease of use, making it accessible for beginners and experts alike.

    • MySQL is highly flexible, supporting various data types and storage engines.

    • It is popular for its scalability, ...

  • Answered by AI
  • Q3. How to retrieve set of data in a database?
  • Ans. 

    To retrieve a set of data in a database, you can use SQL queries to specify the data you want to retrieve.

    • Use SELECT statement to specify the columns you want to retrieve

    • Use FROM clause to specify the table where the data is stored

    • Use WHERE clause to specify any conditions for filtering the data

    • Use ORDER BY clause to specify the order in which the data should be returned

    • Use LIMIT clause to specify the maximum number of

  • Answered by AI
  • Q4. How to know the disk utilization in linux?
  • Ans. 

    To know disk utilization in Linux, use commands like df, du, and iostat.

    • Use 'df' command to display disk space usage on Linux filesystems.

    • Use 'du' command to estimate file space usage.

    • Use 'iostat' command to monitor system input/output device loading.

    • Check disk utilization with tools like 'iotop' and 'atop'.

  • Answered by AI

Skills evaluated in this interview

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

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

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
View all tips
Round 2 - Technical 

(3 Questions)

  • Q1. SQL server architecture
  • Q2. Backup Types and PITR
  • Q3. High availability and Disaster Recovery
Round 3 - Technical 

(2 Questions)

  • Q1. Asked for everything that I mentioned in my resume
  • Q2. Azure services and features
Round 4 - HR 

(1 Question)

  • Q1. Management Process

SQL Database Administrator Interview Questions & Answers

Microland user image Mahesh Kumar Babu Kummara

posted on 20 Jul 2023

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

I applied via Referral and was interviewed before Jul 2022. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Properly align and format text in your resume. A recruiter will have to spend more time reading poorly aligned text, leading to high chances of rejection.
View all tips
Round 2 - Technical 

(4 Questions)

  • Q1. The Architecture of SQL Server
  • Ans. 

    The architecture of SQL Server involves components like storage engine, query processor, and buffer manager.

    • SQL Server architecture consists of multiple components such as storage engine, query processor, and buffer manager.

    • The storage engine manages data storage, retrieval, and modification.

    • The query processor processes SQL queries and generates execution plans.

    • The buffer manager is responsible for managing data cache...

  • Answered by AI
  • Q2. How to troubleshoot high CPU and Memory
  • Ans. 

    To troubleshoot high CPU and Memory, monitor performance metrics, identify resource-intensive queries, optimize queries and indexes, check for memory leaks.

    • Monitor performance metrics using tools like SQL Server Profiler, Performance Monitor, or DMVs.

    • Identify resource-intensive queries using tools like SQL Server Management Studio or query execution plans.

    • Optimize queries and indexes by rewriting queries, adding missin...

  • Answered by AI
  • Q3. Recent issues and resolution
  • Ans. 

    Resolved recent issues related to database performance by optimizing queries and increasing server resources.

    • Identified slow performing queries and optimized them by adding indexes or rewriting them

    • Increased server resources such as CPU, memory, or storage to improve performance

    • Implemented query caching or stored procedures to reduce load on the database server

  • Answered by AI
  • Q4. What is DAG, DNN and VNN
  • Ans. 

    DAG stands for Directed Acyclic Graph, DNN stands for Deep Neural Network, and VNN stands for Virtual Neural Network.

    • DAG is a graph with directed edges and no cycles, commonly used in data processing.

    • DNN is a type of artificial neural network with multiple hidden layers, used in deep learning.

    • VNN is a virtual neural network, a concept that may refer to a neural network implemented in a virtual environment.

  • Answered by AI
Round 3 - HR 

(1 Question)

  • Q1. Salary discussion and shift acceptance

Interview Preparation Tips

Interview preparation tips for other job seekers - Intermediate knowledge of SQL server is required.

Skills evaluated in this interview

Round 1 - Technical 

(1 Question)

  • Q1. Needs to aware of troubleshooting skills

Interview Preparation Tips

Interview preparation tips for other job seekers - Need to aware of troubleshooting skills and knowledge
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
-

I was interviewed before Sep 2022.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Double-check your resume for any spelling mistakes. The recruiter may consider spelling mistakes as careless behavior or poor communication skills.
View all tips
Round 2 - Technical 

(1 Question)

  • Q1. Basic questions like CTE, Recursive cte, stored procedure, index fragmentation
Round 3 - HR 

(1 Question)

  • Q1. General questions

I applied via LinkedIn and was interviewed before Aug 2021. There were 2 interview rounds.

Round 1 - One-on-one 

(1 Question)

  • Q1. Basic technical questions Database Architecture Tablespace management User management Db links/networking Rman backup strategy
Round 2 - Technical 

(1 Question)

  • Q1. Performance tuning Dataguard Rac basic ASM

Interview Preparation Tips

Interview preparation tips for other job seekers - Good place to learn...with medium scale salary but less work load

Clover Infotech Interview FAQs

How many rounds are there in Clover Infotech Senior Oracle Database Administrator interview?
Clover Infotech interview process usually has 3 rounds. The most common rounds in the Clover Infotech interview process are Resume Shortlist, Aptitude Test and One-on-one Round.
What are the top questions asked in Clover Infotech Senior Oracle Database Administrator interview?

Some of the top questions asked at the Clover Infotech Senior Oracle Database Administrator interview -

  1. Depand on profile likeOracle ...read more
  2. Senior person taking 2nd ro...read more

Tell us how to improve this page.

People are getting interviews through

based on 1 Clover Infotech interview
WalkIn
100%
Low Confidence
?
Low Confidence means the data is based on a small number of responses received from the candidates.
Join Clover Infotech Digital Solutions for the New-Age Enterprise

Interview Questions from Similar Companies

TCS Interview Questions
3.7
 • 10.2k Interviews
Infosys Interview Questions
3.7
 • 7.5k Interviews
Wipro Interview Questions
3.7
 • 5.5k Interviews
Tech Mahindra Interview Questions
3.6
 • 3.8k Interviews
HCLTech Interview Questions
3.5
 • 3.7k Interviews
LTIMindtree Interview Questions
3.9
 • 2.9k Interviews
Mphasis Interview Questions
3.4
 • 784 Interviews
KPIT Technologies Interview Questions
3.5
 • 285 Interviews
NeoSOFT Interview Questions
4.0
 • 250 Interviews
View all
Clover Infotech Senior Oracle Database Administrator Salary
based on 23 salaries
₹6.1 L/yr - ₹16.5 L/yr
23% less than the average Senior Oracle Database Administrator Salary in India
View more details

Clover Infotech Senior Oracle Database Administrator Reviews and Ratings

based on 4 reviews

3.3/5

Rating in categories

3.7

Skill development

2.1

Work-Life balance

3.1

Salary & Benefits

4.6

Job Security

2.6

Company culture

3.0

Promotions/Appraisal

3.4

Work Satisfaction

Explore 4 Reviews and Ratings
Software Engineer
1.3k salaries
unlock blur

₹1.8 L/yr - ₹9 L/yr

Senior Software Engineer
826 salaries
unlock blur

₹4 L/yr - ₹15.5 L/yr

Technical Support Engineer
572 salaries
unlock blur

₹2 L/yr - ₹7.5 L/yr

Application Support Engineer
534 salaries
unlock blur

₹2 L/yr - ₹8.5 L/yr

Oracle Database Administrator
470 salaries
unlock blur

₹1.8 L/yr - ₹10 L/yr

Explore more salaries
Compare Clover Infotech with

TCS

3.7
Compare

Wipro

3.7
Compare

Infosys

3.7
Compare

HCLTech

3.5
Compare

Calculate your in-hand salary

Confused about how your in-hand salary is calculated? Enter your annual salary (CTC) and get your in-hand salary
Did you find this page helpful?
Yes No
write
Share an Interview