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

SQL Administrator based Frequently Asked Questions in various SQL Administrator job interviews by interviewer. These professional questions are here to ensures that you offer a perfect answers posed to you. So get preparation for your new job hunting

1 Tell me why would you use SQL Agent?
2 Please explain why would you call Update Statistics?
3 How to start SQL Server in different modes?
4 Tell me what is SQL Server VSS Writer?
5 Do you know what is SQL Server service and its importance?
6 Do you know what is a primary key?
7 Tell us do you have experience working with Hadoop?
8 Tell us how do you open a Cluster Administrator?
9 Tell me what is Transparent Data Encryption?
10 Tell us what the different components of Replication and what is their use?
11 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?
12 Tell us about your SQL Server DBA Experience?
13 Do you know what happens on checkpoint?
14 Do you know what purpose does the model database serve?
15 Tell us can we hot add CPU to SQL server?
16 Tell us what is SQL Server Reporting Services?
17 Tell us what is the difference between a Navigational database and a Relational database?
18 Tell me what's your process for troubleshooting database problems?
19 Tell us on a Windows Server 2003 Active – Passive failover cluster, how do you find the node which is active?
20 Tell us what are the differences in Clustering in SQL Server 2005 and 2008 or 2008 R2?
21 Do you know what is the importance of a recovery model?
22 Tell me what are the new features in SQL Server 2005 when compared to SQL Server 2000?
23 Tell us how do you trace the traffic hitting a SQL Server?
24 Tell us what is a system database and what is a user database?
25 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?
26 Tell me how would you handle data loss during a database migration?
27 Can you list out various services which are important for SQL Server and its components functionality?
28 Tell us which are third-party tools used in SQL Server and why would you use them?
29 Explain me what types of replication are supported in SQL Server?
30 Tell us what are the High-Availability solutions in SQL Server and differentiate them briefly?
31 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?
32 Tell me what is the difference between dropping a database and taking a database offline?
33 Tell me why should I go to all the trouble of creating a database when I have a perfectly good Excel Spreadsheet?
34 Tell us what different steps will a SQL Server Developer takes to secure SQL Server?
35 Tell us how can you control the amount of free space in your index pages?
36 Do you know what is DCL?
37 Tell us what are the different Topologies in which Replication can be configured?
38 Tell me what are the different Authentication modes in SQL Server and how can you change authentication mode?
39 Tell us what is the difference between the 2 operating modes of Database Mirroring?
40 Do you know what ODBC is?
41 Tell us what are the different types of database compression introduced in SQL Server 2008?
42 Tell me what are the commands used in DCL?
43 Tell us what is a correlated sub-query?
44 Please explain what is meant by Active – Passive and Active – Active clustering setup?
45 Tell us what types of databases do you work with?
46 Please explain what is a Database Management System?
47 Do you know what is SQL Server Browser?
48 Tell us what is the difference between Clustered and Non-Clustered Index?
49 Tell us what Is The Difference Between Lock, Block And Deadlock?
50 Tell me when setting Replication, can you have Distributor on SQL Server 2005, Publisher of SQL Server 2008?
51 Tell us does Transparent Data Encryption provide encryption when transmitting data across the network?
52 Tell me what is the default fill factor value?
53 Explain me what is DBCC?
54 Tell me how do you troubleshoot errors in a SQL Server Agent Job?
55 Please explain what the different types of Replication and why are they used?
56 Tell us do you have experience with on-premises databases, cloud databases or both?
57 Tell us what is SQL Server Agent service and its importance?
58 Tell us what are the different SQL Server Versions you have worked on?
59 Tell me what action plan is prefered if SQL Server is not responding?
60 Tell us what is SQL Server Integration service and its importance?
61 Explain me what is a query?
62 Tell us what are the different types of Upgrades that can be performed in SQL Server?
63 Explain me where do you find the default Index fill factor and how to change it?
64 Tell me what authentication modes does SQL Server support?
65 Tell me which autogrowth database setting is good?
66 Do you know what does ‘SELECT’ do?
67 Can you explain about your SQL Server DBA Experience?
68 Explain me what is SQL?
69 Tell us some of the requirements to setup a SQL Server failover cluster?
70 Tell me what are the different SQL Server Versions you have worked on?
71 Explain me what are the operating modes in which Database Mirroring runs?
72 Explain me what is SQL Server Analysis service and its importance?
73 Tell me what is Full-Text Search service?
74 Explain me what is the highest number of database servers you have worked with?
75 Explain me what are the different types of Indexes available in SQL Server?
76 Do you know what is the default Port No on which SQL Server listens?
77 Tell us what is SQL Server VSS Writer?
78 Explain me what is Fill Factor?
79 Explain me what is a Database?
80 Do you know what are the different types of Indexes available in SQL Server?
81 Tell us what is Replication?
82 Tell us what are the different ways you can create Databases in SQL Server?
83 Do you know which types of backups are not supported by SQL Write Service?
84 Tell us what are the recovery models for a database?

Download SQL Administrator Interview Questions And Answers PDF