Search

Interview Questions

  • Reviews
  • Salaries
  • Interview Questions
  • About Company
  • Benefits
  • Jobs
  • Office Photos
  • Community
+ Contribute
notification
notification
Login
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.5

based on 1.2k Reviews

Filter interviews by

Clover Infotech SQL Database Administrator Interview Questions and Answers

Updated 26 Feb 2023

Clover Infotech SQL Database Administrator Interview Experiences

1 interview found

SQL Database Administrator Interview Questions & Answers

user image Anonymous

posted on 26 Feb 2023

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

I applied via Referral and was interviewed before Feb 2022. There were 4 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 

Easy aptitude test. Nothing difficult.

Round 3 - Technical 

(1 Question)

  • Q1. Technical round involves your basic understanding of Database management systems. How it works ? What is the role of a DBA ?
    • Add your answer
Round 4 - HR 

(1 Question)

  • Q1. Very normal HR round
    • Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - If you are a fresher joining as a DBA.
Only con is 3.5 years but you will learn a lot in those years. There will be lot of work.
If you join a MNC as a fresher trust me you won't learn a thing.

Top trending discussions

View All
Salary Discussions, Hike & Promotions
2w (edited)
kirayagami1
Verified Icon
·
works at
TCS
Experience - 5.9 Tech - React.js CTC- 13LPA Current company - TCS Offer in the process - Nagarro (19LPA) My LWD is 24th May, but I told Nagarro I can be released in 30 days. Now, should I: 1. Be honest and say I can join on 25th May? 2. Commit to 25th April and request a DOJ extension later?(By telling them some emergency) Q1). If I choose option 1, is there a risk they won’t release the offer?(As I am being hired for a particular project, so will they go for some immediate candidates?) Q2). If I choose option 2, could they revoke the offer?(As the HR told changing the DOJ in released offer letter is not possible
Nagarro offer: Kindly Help me to decide
Option 1
0%
Option 2
0%
115 participants . poll closed
Got a question about Clover Infotech?
Ask anonymously on communities.

Interview questions from similar companies

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:
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 

(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
    Add your answer
  • 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
    Add your answer
  • 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
    Add your answer
  • 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
    Add your answer
Round 3 - HR 

(1 Question)

  • Q1. Salary discussion and shift acceptance
    • Add your answer

Interview Preparation Tips

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

Skills evaluated in this interview

SQL Database Administrator Interview Questions & Answers

Mastek user image Jessica Gonsalves

posted on 16 Oct 2023

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

I applied via Campus Placement 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
    • Add your answer

Interview Preparation Tips

Topics to prepare for Mastek SQL Database Administrator interview:
  • SQL
  • Logic

Software Engineer Interview Questions & Answers

Happiest Minds Technologies user image Anonymous

posted on 21 Oct 2021

I applied via Campus Placement and was interviewed in Apr 2021. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Questions based on Sql,Data structures and based on sorting algorithm
    • Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident and make sure you know your resume properly

Software Engineer Interview Questions & Answers

NeoSOFT user image Anonymous

posted on 14 Jun 2021

I applied via Campus Placement and was interviewed in May 2021. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. OOPs concept
    • Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Just be yourself.

Software Engineer Interview Questions & Answers

Newgen Software Technologies user image Anonymous

posted on 22 Jul 2021

I applied via Naukri.com and was interviewed in Jan 2021. There were 4 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. OOPS, collection, database
    • Add your answer
  • Q2. Method overload and overrding, interface, abstract class, one small program on string manipulation,database queries
    • Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Have your core java basics revised and keep sound knowledge of your project

Software Engineer Interview Questions & Answers

Newgen Software Technologies user image Anonymous

posted on 14 Sep 2021

I appeared for an interview before Sep 2020.

Round 1 - Coding Test 

(1 Question)

Round duration - 90 minutes
Round difficulty - Medium

Online test of 90 minutes at 5:30 pm

  • Q1. What are the basic concepts of Object-Oriented Programming, and how do they relate to data structures and algorithms?
  • Ans. 

    Object-Oriented Programming concepts include encapsulation, inheritance, and polymorphism, which are used to organize and manipulate data in data structures and algorithms.

    • Encapsulation: Bundling data and methods that operate on the data together in a single unit (object). Example: a class representing a car with properties like color and methods like drive().

    • Inheritance: Allowing a class to inherit properties and meth...

    • Answered by AI
    View 1 more answer
Round 2 - Coding Test 

(2 Questions)

Round duration - 45 minutes
Round difficulty - Medium

Online coding interview of 45 minutes at 6:10PM.

  • Q1. 

    String Compression Problem Statement

    Implement a program that performs basic string compression. When a character is consecutively repeated more than once, replace the consecutive duplicates with the coun...

  • Ans. 

    Implement a program to compress a string by replacing consecutive duplicates with the count of repetitions.

    • Iterate through the string and keep track of consecutive characters and their counts.

    • Replace consecutive duplicates with the count of repetitions.

    • Handle the case where the count of repetitions is greater than 1 and less than or equal to 9.

    • Answered by AI
    Add your answer
  • Q2. Can you explain queries related to insert, selection, and joins in a database management system?
  • Ans. 

    Explanation of insert, select, and join queries in a database management system.

    • Insert query is used to add new records to a table.

    • Select query is used to retrieve data from a table based on specified criteria.

    • Join query is used to combine rows from two or more tables based on a related column between them.

    • Examples: INSERT INTO table_name (column1, column2) VALUES (value1, value2); SELECT * FROM table_name WHERE condit...

    • Answered by AI
    Add your answer
Round 3 - HR 

Round duration - 30 minutes
Round difficulty - Easy

HR round of 30 minutes at 6pm

Interview Preparation Tips

Professional and academic backgroundI applied for the job as Software Engineer in NoidaEligibility criteriaAbove 7 cgpaNewgen Software interview preparation:Topics to prepare for the interview - Data Structures and algorithms(arrays,strings,linked list,graphs,trees,recursion,backtrack),OOPS,Relational Database Management System, Operating SystemTime required to prepare for the interview - 4 monthsInterview preparation tips for other job seekers

Tip 1 : Be accurate in one language rather than doing more languages but not perfect in anyone
Tip 2 : Revise your concepts regularly and try to attempt 3-4 times a question which you cannot do in first time so that after that if u see question of that type u know how to approach 
Tip 3 : Do practice of quality questions not only quantity.

Application resume tips for other job seekers

Tip 1 : One page resume 
Tip 2 : Only mentioned that projects and skills in which you are really good don't write anything just to fulfill the space

Final outcome of the interviewSelected

Skills evaluated in this interview

Software Engineer Interview Questions & Answers

NeoSOFT user image Anonymous

posted on 22 Jul 2021

I applied via Naukri.com and was interviewed in Jan 2021. There were 3 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. More questions on which topic
    • Add your answer
  • Q2. Focus on c#, MVC and SQL
    • Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare well technically and scenario based questions also prepared.

Software Engineer Interview Questions & Answers

Test Yantra Software Solutions user image Anonymous

posted on 14 Sep 2021

I applied via Recruitment Consultant and was interviewed in Oct 2020. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Questions on SDLC & STLC , system testing, regression testing, diff between functional and non functional testing, Smoke testing, Adhoc testing. Some simple SQL questions .
    • Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident and try to answer each amd every question correctly.

Software Engineer Interview Questions & Answers

Newgen Software Technologies user image Brijesh Mishra

posted on 3 Sep 2017

I appeared for an interview in Sep 2017.

Interview Questionnaire 

3 Questions

  • Q1. What is deadlock
  • Ans. 

    Deadlock is a situation where two or more processes are unable to proceed because each is waiting for the other to release a resource.

    • Deadlock occurs when two or more processes are stuck in a circular wait, where each process is waiting for a resource held by another process.

    • Four necessary conditions for deadlock are mutual exclusion, hold and wait, no preemption, and circular wait.

    • Example: Process A holds resource X a...

    • Answered by AI
    Add your answer
  • Q2. Which technology you know and worked
  • Ans. 

    I have experience with various technologies including Java, Python, HTML/CSS, JavaScript, and SQL.

    • Java

    • Python

    • HTML/CSS

    • JavaScript

    • SQL

    • Answered by AI
    Add your answer
  • Q3. Why you are looking for change and what is your notice period
  • Ans. 

    I am looking for a change to explore new opportunities and challenges. My notice period is 30 days.

    • Seeking new opportunities and challenges

    • Want to learn and grow in a different environment

    • Exploring better career prospects

    • Seeking a company with a better work-life balance

    • Notice period is 30 days

    • Answered by AI
    Add your answer

Interview Preparation Tips

Round: Test
Experience: 25 objective ques from Java and 25 from English
Tips: should prepare with Java Technology
Duration: 1 hour
Total Questions: 50

Round: Technical Interview
Experience: describe clearly
Tips: should prepared

Round: Technical Interview
Experience: do you know about jsf
Tips: yes, I worked

Round: Technical + HR Interview
Experience: this is my dream company actually, and notice is 15 to 20 days.
Tips: be confident

Skills evaluated in this interview

More about working at Clover Infotech

Clover Infotech Interview FAQs

How many rounds are there in Clover Infotech SQL Database Administrator interview?
Clover Infotech interview process usually has 4 rounds. The most common rounds in the Clover Infotech interview process are Resume Shortlist, Aptitude Test and Technical.
How to prepare for Clover Infotech SQL 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 Clover Infotech. The most common topics and skills that interviewers at Clover Infotech expect are Database Administration, French, Postgresql, SAN and SQL DBA.
What are the top questions asked in Clover Infotech SQL Database Administrator interview?

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

  1. Technical round involves your basic understanding of Database management system...read more
  2. Very normal HR ro...read more

Tell us how to improve this page.

Clover Infotech Interviews By Designations

Interview Questions for Popular Designations

Clover Infotech SQL Database Administrator Interview Process

based on 1 interview

Interview experience

3
  
Average
View more
Join Clover Infotech Digital Solutions for the New-Age Enterprise

Interview Questions from Similar Companies

ITC Infotech Interview Questions
3.6
 • 337 Interviews
NeoSOFT Interview Questions
3.7
 • 268 Interviews
Newgen Software Technologies Interview Questions
3.7
 • 185 Interviews
3i Infotech Interview Questions
3.5
 • 144 Interviews
Happiest Minds Technologies Interview Questions
3.6
 • 132 Interviews
Microland Interview Questions
3.4
 • 129 Interviews
Test Yantra Software Solutions Interview Questions
3.2
 • 123 Interviews
Sify Technologies Interview Questions
3.8
 • 123 Interviews
Mastek Interview Questions
3.5
 • 120 Interviews
Maveric Systems Interview Questions
3.5
 • 118 Interviews
View all
Clover Infotech SQL Database Administrator Salary
based on 68 salaries
₹2.8 L/yr - ₹9.5 L/yr
27% less than the average SQL Database Administrator Salary in India
View more details

Clover Infotech SQL Database Administrator Reviews and Ratings

based on 15 reviews

4.1/5

Rating in categories

4.2

Skill development

3.5

Work-life balance

3.4

Salary

4.2

Job security

3.9

Company culture

3.5

Promotions

4.1

Work satisfaction

Explore 15 Reviews and Ratings
Clover Infotech Salaries in India
Software Engineer
1.3k salaries
unlock blur

₹1.8 L/yr - ₹9.8 L/yr

Senior Software Engineer
834 salaries
unlock blur

₹4.2 L/yr - ₹15.9 L/yr

Application Support Engineer
582 salaries
unlock blur

₹2 L/yr - ₹8.3 L/yr

Technical Support Engineer
559 salaries
unlock blur

₹2 L/yr - ₹7.5 L/yr

Oracle Database Administrator
500 salaries
unlock blur

₹1.8 L/yr - ₹10.1 L/yr

Explore more salaries
Compare Clover Infotech with

ITC Infotech

3.6
Compare

3i Infotech

3.5
Compare

Sify Technologies

3.8
Compare

Microland

3.5
Compare
Popular Calculators
Are you paid fairly?
Monthly In-hand Salary Calculator
Gratuity Calculator
HRA Calculator
Salary Hike Calculator
Did you find this page helpful?
Yes No
write
Share an Interview