Sql Database Administrator Interview Questions

375 sql database administrator interview questions shared by candidates

1. How the rebuild or reorganize queries work on always on ag database? 2. while reorganizing is it good to reorganize clustor index or non clulstor inxdex and Why? 3. assigning user acess to perticular DB/table/filegroup, How it can be done for individual account or AD Group? 4. SQL server installation process? 5. AZURE Migration process from on prem instance? 6. Always on AG Implementation and solutions for general errors that occur ? 7.why fragmentation occurs, safe fragmentation level and solution for high fragmentation level.
avatar

SQL DBA

Interviewed at Applied Materials

3.9
Jul 10, 2025

1. How the rebuild or reorganize queries work on always on ag database? 2. while reorganizing is it good to reorganize clustor index or non clulstor inxdex and Why? 3. assigning user acess to perticular DB/table/filegroup, How it can be done for individual account or AD Group? 4. SQL server installation process? 5. AZURE Migration process from on prem instance? 6. Always on AG Implementation and solutions for general errors that occur ? 7.why fragmentation occurs, safe fragmentation level and solution for high fragmentation level.

Assume you are mentoring a team and in a span of 6 months all of your team members have left the organization and currently you owe a fresh team. So what would you do to make mission business critical working without impact?
avatar

SQL Server Database Administrator

Interviewed at HCLTech

3.5
Jan 23, 2013

Assume you are mentoring a team and in a span of 6 months all of your team members have left the organization and currently you owe a fresh team. So what would you do to make mission business critical working without impact?

Viewing 211 - 220 interview questions

Glassdoor has 375 interview questions and reports from Sql database administrator interviews. Prepare for your interview. Get hired. Love your job.