Upload Button Icon Add office photos
Engaged Employer

i

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

Mastek Verified Tick

Compare button icon Compare button icon Compare
3.6

based on 748 Reviews

Filter interviews by

Mastek SQL Database Administrator Interview Questions and Answers

Updated 16 Oct 2023

1 interview found

Sort by: Popular

SQL Database Administrator Interview Questions

user image Jessica Gonsalves

posted on 16 Oct 2023

Interview experience
3
 Average
Difficulty level
 Moderate
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.

5 Interview Rounds

1

Resume Shortlist Round

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
2

Aptitude Test Round

Basic Apptitude. SQL & logic in

3

Group Discussion Round

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

4

Group Discussion Round

They took two GD as many people were selected

5

One-on-one Round (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 questions from similar companies

SQL Database Administrator Interview Questions

Microland user image Mahesh Kumar Babu Kummara

posted on 20 Jul 2023

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

I applied via Referral and was interviewed before Jul 2022.

3 Interview Rounds

1

Resume Shortlist Round

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
2

Technical Round (4 Questions)

  • Q1. The Architecture of SQL Server
  • Q2. How to troubleshoot high CPU and Memory
  • Q3. Recent issues and resolution
  • Q4. What is DAG, DNN and VNN
3

HR Round (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

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

I applied via Referral and was interviewed before Feb 2022.

4 Interview Rounds

1

Resume Shortlist Round

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
2

Aptitude Test Round

Easy aptitude test. Nothing difficult.

3

Technical Round (1 Question)

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

HR Round (1 Question)

  • Q1. Very normal HR round

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.
Interview experience
5
 Excellent
Difficulty level
 -
Duration
 Less than 2 weeks
Result
 Not Selected

I applied via Referral and was interviewed in Feb 2024.

2 Interview Rounds

1

Technical Round (2 Questions)

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

Technical Round (2 Questions)

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

1 Interview Round

1

Technical Round (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
4
 Good
Difficulty level
 Moderate
Duration
 Less than 2 weeks
Result
Selected  Selected

I applied via Referral and was interviewed before Sep 2023.

1 Interview Round

1

One-on-one Round (4 Questions)

  • Q1. What is database?
  • Q2. What is MySQL? why it is popular?
  • Q3. How to retrieve set of data in a database?
  • Q4. How to know the disk utilization in linux?

Skills evaluated in this interview

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

I was interviewed before Sep 2022.

3 Interview Rounds

1

Resume Shortlist Round

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
2

Technical Round (1 Question)

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

HR Round (1 Question)

  • Q1. General questions

MS SQL DBA Interview Questions

Microland user image shaik abdul rahiman

posted on 19 Dec 2022

Interview experience
5
 Excellent
Difficulty level
 -
Duration
 -
Result
 -

2 Interview Rounds

1

Resume Shortlist Round

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
2

One-on-one Round (3 Questions)

  • Q1. New SQL Server installation and configuration
  • Q2. Maintaining high availability like log shipping mirroring transactional replication always on and clustering
  • Q3. Database migration from lower version to higher version

Interview Preparation Tips

Interview preparation tips for other job seekers - Worked as a Database Administrator with microland Bangalore

Skills evaluated in this interview

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

I applied via Referral and was interviewed in Apr 2024.

4 Interview Rounds

1

Aptitude Test Round

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

2

HR Round (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 ?
3

Technical Round (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 ...read more
4

HR Round (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

MS SQL DBA Interview Questions

3i Infotech user image Anonymous

posted on 8 Aug 2024

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

I applied via Naukri.com and was interviewed before Aug 2023.

1 Interview Round

1

Technical Round (2 Questions)

  • Q1. Explain locks and latches
  • Q2. Isolation level in DB

Interview Preparation Tips

Interview preparation tips for other job seekers - Easy interview

Mastek Interview FAQs

How many rounds are there in Mastek SQL Database Administrator interview?
Mastek interview process usually has 5 rounds. The most common rounds in the Mastek interview process are Group Discussion, Resume Shortlist and Aptitude Test.

Tell us how to improve this page.

People are getting interviews through

based on 1 Mastek interview
Campus Placement
100%
Low Confidence
?
Low Confidence means the data is based on a small number of responses received from the candidates.

Mastek SQL Database Administrator Reviews and Ratings

based on 1 review

5.0/5

Rating in categories

5.0

Skill development

5.0

Work-Life balance

5.0

Salary & Benefits

5.0

Job Security

5.0

Company culture

5.0

Promotions/Appraisal

5.0

Work Satisfaction

Explore 1 Review and Rating
Senior Software Engineer
573 salaries
unlock blur

₹6 L/yr - ₹21.4 L/yr

Software Engineer
399 salaries
unlock blur

₹2.7 L/yr - ₹8.5 L/yr

Associate Consultant
281 salaries
unlock blur

₹2 L/yr - ₹9 L/yr

Software Specialist
275 salaries
unlock blur

₹7.9 L/yr - ₹29 L/yr

Consultant 1
187 salaries
unlock blur

₹3.4 L/yr - ₹9.5 L/yr

Explore more salaries
Compare Mastek with

TCS

3.7
Compare

Infosys

3.7
Compare

Wipro

3.7
Compare

HCLTech

3.6
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