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

Filter interviews by

Clear (1)

Clover Infotech MS SQL DBA Interview Questions and Answers

Updated 5 May 2024

Clover Infotech MS SQL DBA Interview Experiences

1 interview found

MS SQL DBA Interview Questions & Answers

user image Anonymous

posted on 5 May 2024

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

I applied via Referral and was interviewed in Apr 2024. There were 4 interview rounds.

Round 1 - Aptitude Test 

They took aptitude test in which there was a set of 30 questions like mathematical and logical

Round 2 - HR 

(3 Questions)

  • Q1. Where do you live? Tell me about your family. Will you get shift in another city if required?
  • Q2. Tell me about your family
  • Q3. For which job role are you looking for ?
Round 3 - Technical 

(1 Question)

  • Q1. Tell me about your project. What technologies has been used in your project? Is there anyone in your family who comes from I.T background? And question related to mysql queries
Round 4 - HR 

(1 Question)

  • Q1. In this process HR gives Basic idea regarding salary and ask basic questions

Interview Preparation Tips

Topics to prepare for Clover Infotech MS SQL DBA interview:
  • MySQL

Interview questions from similar companies

I applied via Walk-in and was interviewed in Aug 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 Resume tips
Round 2 - One-on-one 

(2 Questions)

  • Q1. WHAT IS YOUR EXPIRENCE?
  • Q2. WHAT IS YOUR HIGHER GRADUATION PERIOD.

Interview Preparation Tips

Interview preparation tips for other job seekers - MY NAME IS NAVEEN KUMAR . I AM FROM BADVEL. MY HIGHER GRADUATION DEGREE BSC COMPUTERS.
Interview experience
4
Good
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Company Website and was interviewed in Aug 2024. There were 2 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. Dba backups in sql
  • Ans. 

    DBA backups in SQL are essential for data protection and disaster recovery.

    • Regularly schedule full, differential, and transaction log backups to ensure data is protected.

    • Store backups in secure locations to prevent data loss in case of hardware failure or corruption.

    • Test backups regularly to ensure they can be restored successfully in case of emergency.

  • Answered by AI
  • Q2. Dba replication
Round 2 - HR 

(2 Questions)

  • Q1. Tell me about urself
  • Ans. 

    I am a dedicated and experienced MS SQL DBA with a strong background in database administration and performance tuning.

    • Over 5 years of experience working as a MS SQL DBA

    • Proficient in database administration tasks such as backup and recovery, performance tuning, and security

    • Skilled in troubleshooting and resolving database-related issues

    • Experience with SQL Server Integration Services (SSIS) and SQL Server Reporting Serv...

  • Answered by AI
  • Q2. Strengths and weakness

Skills evaluated in this interview

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

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

Round 1 - Technical 

(4 Questions)

  • Q1. Start up parameters of sql server
  • Ans. 

    Start up parameters are used to configure the behavior of SQL Server when it starts up.

    • Start up parameters are specified in the SQL Server Configuration Manager.

    • Common start up parameters include -d (database files location), -e (error log location), -m (single user mode), -T (trace flags), etc.

    • Start up parameters can be modified to customize the behavior of SQL Server during startup.

    • Example: -dC:\Program Files\Microso...

  • Answered by AI
  • Q2. Differential backup query
  • Q3. Sql server statics
  • Q4. Log file architecture

Interview Preparation Tips

Interview preparation tips for other job seekers - kindly prepare all the topics about sql server.

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - HR 

(2 Questions)

  • Q1. Share your experience about your company with us
  • Q2. Tell me about roles and responsibilities
Round 2 - HR 

(2 Questions)

  • Q1. What ctc are you expecting
  • Ans. 

    I am expecting a competitive salary based on my experience, skills, and the market rate for MS SQL DBAs.

    • I am looking for a salary that reflects my expertise in MS SQL Server administration.

    • I am open to negotiation based on the specific responsibilities and benefits offered.

    • I have researched the average salary range for MS SQL DBAs in this location and industry.

    • I am also considering other factors such as opportunities f

  • Answered by AI
  • Q2. Are you willing to relocate

Interview Preparation Tips

Interview preparation tips for other job seekers - very good

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

Interview Questionnaire 

1 Question

  • Q1. Personal Details, Strength and Strong Areas, SQL Server Performance Optimization, Windows Clustering, Always On, Shipping, Mirroring, Replication.

Interview Preparation Tips

Interview preparation tips for other job seekers - 1.Personal Details
2.Communication must be good
3.Strong Knowledge of Technology and the fundamentals
4.Resume Should be Good
5.Show Your Good areas
6.Be Confident While Interview

MS SQL DBA Interview Questions & Answers

TCS user image urugonda soumya

posted on 15 Jul 2024

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

I applied via Recruitment Consulltant and was interviewed in Jun 2024. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. What are the steps involved in migration
  • Ans. 

    Steps involved in migration process

    • Assess current environment and identify migration goals

    • Choose migration method (manual, scripted, tool-based)

    • Prepare target environment and perform data migration

    • Test migrated data and applications for functionality

    • Implement post-migration tasks like user training and support

  • Answered by AI
  • Q2. How to do migrating from 2008 to 2019
  • Ans. 

    Migrating from SQL Server 2008 to 2019 involves upgrading the database, transferring data, and testing for compatibility.

    • Perform a side-by-side upgrade by installing SQL Server 2019 on a new server and transferring databases using backup and restore or detach and attach methods.

    • Use the Data Migration Assistant tool to assess compatibility issues and plan for any necessary changes.

    • Update applications and scripts to ensu...

  • Answered by AI

Skills evaluated in this interview

I was interviewed in Sep 2017.

Interview Questionnaire 

4 Questions

  • Q1. Technical interview take by client technical person actually they are hiring for another client so they took total 3 technical round and final will HR round
  • Q2. Asking about life cycle of Dot net mvc contols entity frame work and SQL queries
  • Q3. Problem based on oops and SQL queries outputs
  • Q4. Basic questions about my self ,salary discussion basic formalities form I have to fill up

Interview Preparation Tips

Round: Test
Experience: There were around 15 objective question that includes mvc, c#.net and SQL server. It was very simple question like different types of filters,Acton results in mvc. Basic oops concept and dot net web page regarding

Round: Resume Shortlist
Experience: After completing test round another was technical round discussed maily for mvc and SQL server questions. Around 30 mint discussion. After qualify this round another round will start from client technical staff.

General Tips: It was for 2-3 year experience person very simple to crack but focus on you which profile you are looking for study interview questions from net
Skills: Dot net mve oops concept jQuery and SQL server

I was interviewed before Aug 2016.

Interview Preparation Tips

Round: General and technical aptitude
Experience: There were questions on basics of programming and general questions on verbal,reasoning and quantitative.
Tips: Time will be short to answer all so keep watch on time

Round: Group Discussion
Experience: They segregated us in to batches and in our team there were 10 members.
Tips: Easy round
Duration: 15 minutes

Round: Telephonic
Experience: They tested my communication skill in that round

College Name: Dhanalakshmi college of engineering

Interview Preparation Tips

Round: Test
Experience: Approx. 30.questions in 50 min
Tips: Try solving each que in less than a minute ,don't waste time on difficult questions, complete easier once first
Duration: 50 minutes
Total Questions: 30

College Name: Pimpri chinchwad college of engineering
Contribute & help others!
anonymous
You can choose to be anonymous

Clover Infotech Interview FAQs

How many rounds are there in Clover Infotech MS SQL DBA interview?
Clover Infotech interview process usually has 4 rounds. The most common rounds in the Clover Infotech interview process are HR, Aptitude Test and Technical.

Recently Viewed

INTERVIEWS

BNY

No Interviews

INTERVIEWS

UBS

No Interviews

SALARIES

ANZ Banking Group

REVIEWS

Electronica Finance

No Reviews

INTERVIEWS

KGISL

No Interviews

SALARIES

Dolat Capital Market

No Salaries

DESIGNATION

LIST OF COMPANIES

Dolat Capital Market

Overview

COMPANY BENEFITS

Dolat Capital Market

No Benefits

JOBS

HCLTech

No Jobs

Tell us how to improve this page.

Clover Infotech MS SQL DBA Interview Process

based on 1 interview

Interview experience

4
  
Good
View more
Join Clover Infotech Digital Solutions for the New-Age Enterprise

MS SQL DBA Interview Questions from Similar Companies

View all
Clover Infotech MS SQL DBA Salary
based on 67 salaries
₹2.4 L/yr - ₹7.8 L/yr
28% less than the average MS SQL DBA Salary in India
View more details

Clover Infotech MS SQL DBA Reviews and Ratings

based on 6 reviews

3.0/5

Rating in categories

4.2

Skill development

3.0

Work-life balance

2.8

Salary

4.2

Job security

3.7

Company culture

3.2

Promotions

3.7

Work satisfaction

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

₹0 L/yr - ₹0 L/yr

Senior Software Engineer
839 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Application Support Engineer
569 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Technical Support Engineer
563 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Oracle Database Administrator
489 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Clover Infotech with

TCS

3.7
Compare

Wipro

3.7
Compare

Infosys

3.6
Compare

HCLTech

3.5
Compare
Did you find this page helpful?
Yes No
write
Share an Interview
Rate your experience using AmbitionBox
Terrible
Terrible
Poor
Poor
Average
Average
Good
Good
Excellent
Excellent