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?

1037

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

1099

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

981

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

997

What is the temp table?

874

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

1150

List some advantages and disadvantages of stored procedure?

978

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

907

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

896

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

1039

What are the different types of locks in the database?

881

Why use “pivot” in sql server?

1052

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

1344

What is built-in/administrator?

965

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

904

Un-Answered Questions { SQL Server }

What is Transparent Data Encryption?

946

How do you know if sql server is running on your local system?

990

What is system stored procedures?

985

How to use the inserted and deleted pseudo tables?

922

Is it possible for a stored procedure to call itself or recursive stored procedure?

905

What is executereader?

900

What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.

2720

How can we check the sql server version?

995

What is acid properties?

1031

What is an index in a database?

930

What is trigger and different types of Triggers?

1083

What is tabulation?

902

Do you think BCNF is better than 2NF & 3NF? Why?

1235

What are the difference between primary key and unique key? : sql server database administration

911

How to execute stored procedure and set temp table in sql server?

1004

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