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?

924

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?

930

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

1090

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?

1397

What is built-in/administrator?

1006

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

956

Un-Answered Questions { SQL Server }

Explain the purpose of indexes?

977

How many tables can be joined in SQL Server?

1065

what protocol both networks use? : Sql server database administration

972

You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?

1073

What is the maximum size of column in sql server?

893

Define normalisation?

1118

What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?

914

Are all views updatable ?

1152

How to create new databases with "create database" statements?

1022

How to loop through result set objects using mssql_fetch_array()?

1083

What is sql sandbox in sql server?

1227

What to perform pattern match with the like operator?

883

How to use subqueries with the exists operators in ms sql server?

1119

What is a partitioned view?

992

what is hash nonclustered index

969

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