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

  • Employee Management

    Employee Management: Discover the essential tools, tips, and processes to build and lead a winning team. Learn how to effectively manage performance, foster collaboration, and create a positive work environment that drives success. Implement best practices to optimize productivity and ensure your team reaches its full potential.

    Learn more

  • Talent Sourcing

    Talent Sourcing is all about identifying and engaging with the best-fit talent for your organization. In this section, we explore all the strategies and best practices you can use to discover top talent effectively. Whether you're a seasoned talent sourcer, an HR Manager or just starting to explore the world of proactive recruitment, dive into our blog posts, gain inspiration, and take actionable steps toward building a strategic sourcing approach that ensures you never miss out on top talent.

    Learn more

  • Video in Recruitment

    Discover how incorporating video can enhance your recruitment strategy. From video job postings to candidate video submissions and virtual interviews, video adds a personal touch, increases engagement, and streamlines the hiring process. Learn how to use video to attract, assess, and connect with top talent more effectively.

    Learn more

  • Remote Work

    In the evolving landscape of work, remote work has emerged as a transformative force that empowers both organizations and employees. It is a dynamic shift in how we approach work and the workplace. In this Remote Work resource section, we explore the strategies, best practices, and technologies that HR professionals, managers, and employees can utilize to excel in a remote work environment.

    Learn more

  • Diversity Equity and Inclusion (DEI)

    Diversity, equity, and inclusion (DEI) have become key focuses in building a thriving workplace culture—and for good reason. In our DEI Hub, we provide strategies, insights, and best practices to help HR professionals, business leaders, and change-makers champion a more inclusive and equitable workforce. Join us in fostering diversity and empowering employees by exploring a wide range of DEI topics, from inclusive hiring practices to creating a workplace where all voices are heard and valued.

    Learn more

  • Recruitment Agencies

    Discover how recruitment agencies can efficiently source, screen, and place top candidates tailored to your needs. Explore the advantages of partnering with specialized agencies that understand your industry and deliver quality talent faster, saving you time and resources in the hiring process. Discover the pros and cons of using a recruitment agency.

    Learn more

Simple and affordable recruitment software

Schedule a Demo Start Free Trial