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 }

what types of replication are supported in sql server? : Sql server database administration

1046

You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?

2147

Explain the working of sql privileges?

1091

What are the different sql server versions?

980

what is database replicaion? : Sql server database administration

1195

explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

1054

Explain what is log shipping?

1136

What is log in sql server?

1146

How to retrieve error messages using mssql_get_last_message()?

1054

What is ems sql management studio? : sql server management studio

1111

What is page in sql server?

947

What is user-defined inline table-valued function?

950

You want to implement the one-to-one relationship while designing tables. How would you do it?

965

What are two difference between sql azure and azure tables?

159

What are page splits? : SQL Server Architecture

989

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