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?

1186

Distinguish between commit and rollback?

1011

Explain subquery and state its properties?

1090

What do you understand by a stored procedure?

1153

What is coalesce and check constraint in sql server?

1175

What are the purposes of floor and sign functions?

1018

What is a virtual table in sql?

1036

Explain cdc and sql injection?

1042

State the difference between local and global temporary tables?

1166

Explain cross join or cartesian product in sql?

927

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

1110

Explain tablesample?

1038

Differentiate between truncate vs delete in mssql?

1161

How are the exceptions handled in sql server programming?

1119

Mention the uses of stored procedures.

1007

Un-Answered Questions { SQL Server }

What options are available to audit login activity? : sql server security

1199

How to use order by with union operators in ms sql server?

1065

Explain full-text query in sql server?

1054

What is star, snowflake and star flake schema? : sql server analysis services, ssas

1229

Why we need sql server?

1014

What is the difference between functions and scalar functions?

1278

What is a covering index?

1042

What is stretch database in sql server?

1120

List out the difference between union and union all in sql server?

1040

Why use view instead of a table?

1003

What is the maximum size per database for sql server express?

1103

What is the difference between resultset and resultsetmetadata?

1030

What are basics of policy management?

1150

What is meant by referential integrity?

1046

Different types of keys in SQL?

1141

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