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?

1127

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

1114

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

1139

What are the recovery models for a database?

1146

What is the importance of a recovery model?

1094

What is Replication?

1107

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

1129

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

1126

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

1237

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?

1175

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

1126

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

1101

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

1272

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

1122

What is Transparent Data Encryption?

1059

Un-Answered Questions { SQL Server }

Why do you want to join software field as you have done your BE in Electronics?

2195

What is 2nf in normalization?

1055

Explain the concept of view and Types of views in SQL server?

1034

what type of index will get created after executing the above statement? : Sql server database administration

1028

Explain primary key and foreign key constraints?

1089

Which command is used for user defined error messages?

1104

How to connect sql server management studio express to sql server 2005 express?

1102

Can binary strings be converted into numeric or float data types?

1096

What are the different types of collation sensitivity?

1176

What is transaction server implicit?

1064

Why does sql studio use a single registered database repository? : sql server management studio

1037

Which are ddl commands?

1113

What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio

1186

What is co-related sub query?

1072

How to convert a unicode strings to non-unicode strings?

1154

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