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 isolation levels?

1088

What are the default system databases in sql server 2000?

1085

What does the not null constraint do?

1182

How to rebuild master databse?

1130

What command would you use to create an index?

1114

What command do we use to rename a database?

1125

Do comments need to go in a special place in sql server 2005?

921

What is the purpose of the model database?

1071

What is the sql server 2000 version number?

1152

Name 3 ways to get an accurate count of the number of records in a table?

1091

What is the difference between a local and a global temporary table?

1178

What is difference between delete & truncate commands?

1147

What stored by the msdb?

1049

Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?

1124

What command must you use to include the not null constraint after a table has already been created?

1244

Un-Answered Questions { SQL Server }

Is there any difference between primary key and unique with the not null condition?

1003

What are trace flags and mention a few common trace flags used with sql server?

1144

What is the process of normalization?

1186

What is lock escalation and what is its purpose?

1030

last function used in MS Access to convert sql what function will use in sql

2116

What is Federation and Federation Member?

What are the new scripting capabilities of ssms? : sql server management studio

1125

Can two tables share the same primary key?

987

What is a transactions?

1090

How do you delete a trigger?

1035

What is the purpose of indexing?

1097

What are sub reports and how to create them?

144

Explain what is cte (common table expression)?

1192

What are the different types of replication are there in sql server 2000?

1091

Which joins are sql server default?

1076

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