Junior Database Administrator (DBA) Interview Questions

Junior Database Administrator (DBA) Interview Questions and Answers

This set of interview questions for Junior Database Administrators (DBA interview questions) help you evaluate candidates' skills and qualifications to make more informed hiring decisions.

Junior Database Administrator (DBA) Interview Questions

Interview questions for Junior Database Administrators (DBA)

Here is a sample of DBA interview questions and answers:

DBA interview question #1:

What is the maximum number of clustered indexes a table can have? 
Answer: 1

DBA interview question #2:

Can you tell what types of outer joins exist in SQL Server 2016?
Answer: LEFT, RIGHT, FULL

DBA interview question #3:

What types of table or column constraints we have?
Answer: NOT NULL, PRIMARY KEY, FOREIGN KEY, UNIQUE, CHECK

DBA interview question #4:

If we create many non-clustered indexes on a table, what operations are likely to be considerably slower than before?
Answer: Write operations (INSERT, UPDATE, DELETE, MERGE)

DBA interview question #5:

The choice of a clustering key columns of a clustered index is crucial for performance. Name at least two characteristics that a good clustering key should have.
Answer: UNIQUE, SLIM SIZE (small width in bytes), EVER INCREASING, fixed width, not null

DBA interview question #6:

When we talk about non-clustered index, how many KEY columns can it have and how many INCLUDED columns?
Answer: 16 key columns and unlimited include columns (all table columns can be included).  Answering 1 is really bad. Answer between 2-15 is not that bad. 16 is correct.

DBA interview question #7:

In a trigger that fires after UPDATE of a table, what are the names of the metatables we can access within a trigger code to check which rows were updated?
Answer: INSERTED, DELETED

DBA interview question #8:

When users complain about performance, what is the name of the procedure you can use to quickly list the current sessions and see what are they doing or waiting for? 
Answer: sp_who2 or sp_WhoIsActive (one is enough)

DBA interview question #9:

What DMV stands for?
Answer: Dynamic Management View

DBA interview question #10:

What types of a backup do we need, if we want to restore to a point in time? 
Answer: FULL, LOG, and optionally DIFFERENTIAL

Looking for more great interview questions to ask job candidates?

Our list of interview questions and job descriptions templates can help you improve your quality of new hires. 

Ultimate Guide for Conducting Job Interviews

Get our free eBook, and learn about the best practices for conducting job interviews

Get the Guide

2019 Guide for Buying a Recruiting Tool

Download this guide with useful advices for buying a recruiting software tool that will help you improve your hiring efforts.

Get the Guide
TalentLyft ATS

Your Hiring Teammate

TalentLyft is intuitive and simple recruitment software specialized for SMBs.
Try it free for 14 days!
No credit card required, unsubscribe at any time.