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 are the triggers in sql?

1105

How to use “drop” keyword in sql server and give an example?

1131

What are the advantages of user-defined functions over stored procedures in sql server?

1043

Are null values the same as that of zero or a blank space?

1040

What is the temp table?

923

How do you maintain database integrity where deletions from one table will automatically cause deletions in another table?

1194

List some advantages and disadvantages of stored procedure?

1016

What factors you will consider calculating the storage requirement for that view?

949

List out different types of normalizations in sql server and explain each of them?

929

What are the different authentication modes in sql server? How can it be changed?

1089

What are the different types of locks in the database?

925

Why use “pivot” in sql server?

1119

Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?

1396

What is built-in/administrator?

1005

What is the difference between a unique key and primary key?

955

Un-Answered Questions { SQL Server }

Write down the syntax and an example for create, rename and delete index?

985

Differentiate between a primary key and a unique key.

1071

How do I clean up sql server transaction log?

1066

What’s the distinction between dropping a info and taking a info offline?

1038

what is the maximum size of a row? : Sql server database administration

1014

Can you index views?

895

Explain alternate key, candidate key and composite key in sql server?

915

How are the unique and primary key constraints different?

1075

what are the different ways of moving data/databases between servers and databases in sql server? : Sql server database administration

980

Do you know what are the steps to process a single select statement?

974

What is 2nf in normalization?

997

When does a workload on SQL Azure get throttled?

131

What is an identity column in insert statements?

1023

Do you know how to store and query spatial data?

1039

Explain what is the purpose of sql profiler in sql server?

1076

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