Basic and Advance databases programming ➔ SQL Administrator Job Interview Questions and Answers

SQL Administrator job interview preparation guide for freshers, professionals and experienced candidates. Explore list of SQL Administrator frequently asked questions(FAQs) extracted from many real job interviews

✫ Tell us what are the recovery models for a database?
✫ Do you know which types of backups are not supported by SQL Write Service?
✫ Tell us what are the different ways you can create Databases in SQL Server?
✫ Tell us what is Replication?
✫ Do you know what are the different types of Indexes available in SQL Server?
✫ Explain me what is a Database?
✫ Explain me what is Fill Factor?
✫ Tell us what is SQL Server VSS Writer?
✫ Please explain what is a Database Management System?
✫ Do you know what is the default Port No on which SQL Server listens?
✫ Explain me what are the different types of Indexes available in SQL Server?
✫ Explain me what is the highest number of database servers you have worked with?
✫ Tell me what is Full-Text Search service?
✫ Explain me what is SQL Server Analysis service and its importance?
✫ Explain me what are the operating modes in which Database Mirroring runs?
✫ Tell me what are the different SQL Server Versions you have worked on?
✫ Tell us some of the requirements to setup a SQL Server failover cluster?
✫ Explain me what is SQL?
✫ Can you explain about your SQL Server DBA Experience?
✫ Do you know what does ‘SELECT’ do?
✫ Tell me which autogrowth database setting is good?
✫ Tell me what authentication modes does SQL Server support?
✫ Explain me where do you find the default Index fill factor and how to change it?
✫ Tell us what are the different types of Upgrades that can be performed in SQL Server?
✫ Explain me what is a query?
✫ Tell us what is SQL Server Integration service and its importance?
✫ Tell me what action plan is prefered if SQL Server is not responding?
✫ Tell us what are the different SQL Server Versions you have worked on?
✫ Tell us what is SQL Server Agent service and its importance?
✫ Tell us do you have experience with on-premises databases, cloud databases or both?
✫ Please explain what the different types of Replication and why are they used?
✫ Tell me how do you troubleshoot errors in a SQL Server Agent Job?
✫ Explain me what is DBCC?
✫ Tell me what is the default fill factor value?
✫ Tell us does Transparent Data Encryption provide encryption when transmitting data across the network?
✫ Tell me when setting Replication, can you have Distributor on SQL Server 2005, Publisher of SQL Server 2008?
✫ Tell us what Is The Difference Between Lock, Block And Deadlock?
✫ Tell us what is the difference between Clustered and Non-Clustered Index?
✫ Do you know what is SQL Server Browser?
✫ Tell us what types of databases do you work with?
✫ Please explain what is meant by Active – Passive and Active – Active clustering setup?
✫ Tell us what is a correlated sub-query?
✫ Tell me what are the commands used in DCL?
✫ Tell us what are the different types of database compression introduced in SQL Server 2008?
✫ Do you know what ODBC is?
✫ Tell us what is the difference between the 2 operating modes of Database Mirroring?
✫ Tell me what are the different Authentication modes in SQL Server and how can you change authentication mode?
✫ Tell us what are the different Topologies in which Replication can be configured?
✫ Do you know what is DCL?
✫ Tell us how can you control the amount of free space in your index pages?
✫ Tell us what different steps will a SQL Server Developer takes to secure SQL Server?
✫ Tell me why should I go to all the trouble of creating a database when I have a perfectly good Excel Spreadsheet?
✫ Tell me what is the difference between dropping a database and taking a database offline?
✫ Suppose you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?
✫ Tell us what are the High-Availability solutions in SQL Server and differentiate them briefly?
✫ Explain me what types of replication are supported in SQL Server?
✫ Tell us which are third-party tools used in SQL Server and why would you use them?
✫ Can you list out various services which are important for SQL Server and its components functionality?
✫ Tell me how would you handle data loss during a database migration?
✫ Tell us when setting Replication, is it possible to have a Publisher as 64 Bit SQL Server and Distributor or Subscribers as a 32 Bit SQL Server?
✫ Tell us what is a system database and what is a user database?
✫ Tell us how do you trace the traffic hitting a SQL Server?
✫ Tell me what are the new features in SQL Server 2005 when compared to SQL Server 2000?
✫ Do you know what is the importance of a recovery model?
✫ Tell us what are the differences in Clustering in SQL Server 2005 and 2008 or 2008 R2?
✫ Tell us on a Windows Server 2003 Active – Passive failover cluster, how do you find the node which is active?
✫ Tell me what's your process for troubleshooting database problems?
✫ Tell us what is the difference between a Navigational database and a Relational database?
✫ Tell us what is SQL Server Reporting Services?
✫ Tell us can we hot add CPU to SQL server?
✫ Do you know what purpose does the model database serve?
✫ Do you know what happens on checkpoint?
✫ Tell us about your SQL Server DBA Experience?
✫ Tell us how many files can a Database contain in SQL Server?How many types of data files exist in SQL Server? How many of those files can exist for a single database?
✫ Tell us what the different components of Replication and what is their use?
✫ Tell me what is Transparent Data Encryption?
✫ Tell us how do you open a Cluster Administrator?
✫ Tell us do you have experience working with Hadoop?
✫ Do you know what is a primary key?
✫ Do you know what is SQL Server service and its importance?
✫ Tell me what is SQL Server VSS Writer?
✫ How to start SQL Server in different modes?
✫ Please explain why would you call Update Statistics?
✫ Tell me why would you use SQL Agent?

Download SQL Administrator Job Interview Questions And Answers PDF