Interview Questions

Senior Database Administrator (DBA) Interview Questions

This set ofinterview questions for Senior Database Administrators (DBA interview questions)will help you evaluate candidates’ skills and qualifications to make more informed hiring decisions.

Interview questions for Senior Database Administrators (DBA)

➡️ Download The Ultimate Candidate Interview & Employee Onboarding Checklist!

Interview questions for Senior Database Administrators (DBA interview questions)

Here is a sample of DBA interview questions and answers:

SQL DBA interview question #1:

A table without a clustered index is called…?Answer: HEAP

SQL DBA interview question #2:

How many bytes an index key can have at the maximum in SQL Server 2016? Answer: 900

SQL DBA interview question #3:

Can you tell what types of APPLY operators exist in SQL Server 2016? Answer: OUTER APPLY, CROSS APPLY

SQL DBA interview question #4:

What type of an index can have less rows than it’s table? Answer: FILTERED index

SQL DBA interview question #5:

Name two reasons why would UNIQUEIDENTIFIER data type (aka GUID) be a bad choice for a clustered key? Answer: Because of FRAGMENTATION it causes and large SIZE (16 bytes)

SQL DBA interview question #6:

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

SQL DBA interview question #7:

Wi have a single UPDATE command that changes 100 rows of a table. Table has trigger that fires after update. How many rows do we have in INSERTED, UPDATED and DELETED metatables that we can access within a trigger code? Answer: INSERTED: 100 rows, DELETED: 100 rows, UPDATED: that is made up (does not exist)

SQL DBA interview question #8:

If not executing on the CPU, sessions wait for various things. What should we use to programmatically check what the sessions are waiting for, in cumulative total of all the sessions from the start of the server? Answer: DMV called sys.dm_wait_stats. The answer „a DMV exists but I cannot recall it’s name“ is not bad also.

SQL DBA interview question #9:

In which recovery models the minimally logged operation is possible to occur? Answer: SIMPLE and BULK_LOGGED. (If he mentiones FULL in addition to those two, it is a wrong answer)

SQL DBA interview question #10:

We have a database in full recovery model, and transaction log file size of 100 GB. We have a long running transaction, running for many hours. If the last log backup was taken just now, how big the log backup file will be if we take another log backup immediately after this one? Answer: 0MB (or close to zero)

Need more interview questions to ask job candidates?

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

See TalentLyft in action

Applicant Tracking, Recruitment Marketing, Sourcing and Talent CRM software are powerful alone, but unstoppable when used together!


Related content

Explore more topics

  • Employer branding

    Employer Branding: Strengthen your company's reputation as an employer of choice. Learn how to showcase your culture, values, and work environment to attract top talent. Build a strong employer brand that sets you apart from competitors, enhances candidate attraction, and boosts employee retention for long-term success.

  • Culture Fit

    Ensure culture fit in your hiring process with strategies that align candidates’ values and behaviors with your company’s culture. Learn how to assess cultural compatibility during interviews, foster a positive workplace environment, and build a team that not only excels in skills but thrives within your organization's unique culture.

  • Career Site

    Create a compelling career site that attracts top talent and showcases your company’s culture and opportunities. Learn how to design a user-friendly, engaging platform where potential candidates can explore job openings, learn about your organization, and apply with ease. Boost your employer branding and enhance your recruitment efforts with an optimized career site.

  • Employee Onboarding

    In the journey to build a cohesive and productive workforce, effective employee onboarding is the foundation of success. Employee onboarding isn't just a checklist - it's an essential process that sets the tone for an employee's entire tenure at your organization. Learn about the strategies, best practices, and technologies you can implement at your organization to create seamless and impactful onboarding experiences that st your workforce for future success.

  • Social Recruiting

    The landscape of recruitment is evolving, and social media has become a game-changer in the search for top talent. Social recruiting is not just a trend - it's a strategic approach to finding, engaging, and hiring the right candidates. Learn how to leverage the power social media to scale your recruitment efforts.

  • Recruiting Stats

    Stay informed with the latest recruitment statistics that can help you refine your hiring strategies. Discover key metrics on time-to-hire, candidate sourcing, retention rates, and more. Use these data-driven insights to improve your talent acquisition processes and make better hiring decisions.

Simple and affordable recruitment software