SQL Server Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

SSRS SQL Server Reporting Services (140)
Microsoft Azure SQL (73)

SQL Server Interview Questions

Questions Answers Views Company eMail

What is the default fill factor value?

1143

Where do you find the default Index fill factor and how to change it?

1129

What is a system database and what is a user database?

1153

What are the recovery models for a database?

1160

What is the importance of a recovery model?

1102

What is Replication?

1115

What the different types of Replication and why are they used?

1144

What the different components of Replication and what is their use?

1132

What are the different Topologies in which Replication can be configured?

1256

If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?

1191

What are the different Authentication modes in SQL Server and how can you change authentication mode?

1139

What are the differences in Clustering in SQL Server 2005 and 2008 or 2008 R2?

1109

What is meant by Active-Passive and Active-Active clustering setup?

1284

List out a number of the wants to setup a SQL Server failover cluster?

1140

What is Transparent Data Encryption?

1063

Un-Answered Questions { SQL Server }

What is transact-sql ddl trigger?

1155

What is the optimal disk configuration for a database server and what raid configurations would you use if budget is not a constraint?

1042

How to create a view with data from multiple tables?

1071

What is difference between join and natural join?

1069

How to choose all records from the table?

1115

Mention the different types of triggers?

1227

Define cursor locking

1063

What are the basic functions for master, msdb, model, tempdb databases?

1100

What stored by the msdb?

1052

What does dml stand for?

1012

What is the simplest way to create a new database in ms sql server?

1056

do you know how to configure db2 side of the application? : Sql server database administration

1103

What is linked report?

138

What are the drawbacks of reporting in ssrs?

159

What is ddl and dml commands?

966

For More Un-Answered { SQL Server } Questions Click Here