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 disadvantages of using the stored procedures?

1194

Distinguish between commit and rollback?

1017

Explain subquery and state its properties?

1098

What do you understand by a stored procedure?

1158

What is coalesce and check constraint in sql server?

1179

What are the purposes of floor and sign functions?

1025

What is a virtual table in sql?

1039

Explain cdc and sql injection?

1045

State the difference between local and global temporary tables?

1175

Explain cross join or cartesian product in sql?

933

What is sql server agent and what are the two modes of authentication in sql server?

1113

Explain tablesample?

1046

Differentiate between truncate vs delete in mssql?

1172

How are the exceptions handled in sql server programming?

1119

Mention the uses of stored procedures.

1011

Un-Answered Questions { SQL Server }

What are the different type of replication in sql server?

1023

which table keeps the locking information? : Sql server administration

1140

How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?

1174

How to Check if table exists in sql server?

1192

Describe the functionalities that views support.

1153

How to choose all records from the table?

1113

Explain identity in sql server?

1057

What is the purpose of a table?

1001

What is the difference between inner join and equi join?

1044

What is coalesce and check constraint in sql server?

1179

Why should we go for stored procedures? Why not direct queries?

1162

what is database replicaion? : Sql server database administration

1277

How to transfer data from a cursor to variables with a "fetch" statement?

1149

Define compound operators?

972

Explain about extended stored procedure?

995

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