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?

1166

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

1189

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

1114

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

1088

What is the temp table?

974

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

1246

List some advantages and disadvantages of stored procedure?

1063

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

990

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

971

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

1138

What are the different types of locks in the database?

972

Why use “pivot” in sql server?

1174

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

1449

What is built-in/administrator?

1073

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

1003

Un-Answered Questions { SQL Server }

What have included columns when we talk about sql server indexing?

1074

What are the parts of a function?

982

Which is better statement or preparedstatement?

983

What is inner join in sql server joins?

1096

Explain primary key?

1005

What is a collation?

1131

How is foreign key related to primary key?

1010

Explain stored procedure?

1108

What is user defined datatypes and when you should go for them?

1067

How optimize sql query with multiple joins in sql server?

952

How can you know if the row fetched from cursor is still valid in underlying table?

1043

Explain transaction server consistency?

1017

whats the maximum size of view state??

2248

How to find out the list schema name and table name for the database?

978

Is it possible to replicate data from sql server to oracle? : sql server replication

1140

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