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

Explain what are magic tables in sql server?

1048

Tell me what are cursors and when they are useful?

998

Do you know what is a linked server in sql server?

1072

Do you know what is difference between stored procedure and user defined function?

1156

Tell me when is the update_statistics command used?

1207

Explain the xml support sql server extends?

1086

Explain the rules for designing files and file groups in sql server?

1022

Do you know what is rank function?

1128

Tell me what is normalization? Explain different forms of normalization?

1075

Do you know what are acid properties?

1124

Do you know what are the steps to process a single select statement?

1020

Explain what is public role in sql server?

1194

Do you know how to send email from database?

1053

Explain what is analysis service repository?

1051

What is the order in which the sql query is executed?

994

Un-Answered Questions { SQL Server }

Explain what are the basic functions for master, msdb, model, tempdb databases?

1031

How to bind a view to the schema of the underlying tables?

1050

What is user-defined function?

1035

What are the filtered indexes?

1097

What are different types of raid configurations? : SQL Server Architecture

1138

Explain acid?

1146

How would you choose between a clustered and a non-clustered index?

1023

Explain different types of lock modes in sql server 2000?

986

What is the purpose of update statistics and scope_identity() function?

1160

How to create new tables with "create table" statements in ms sql server?

1111

What is subquery? Explain the properties of a subquery?

1040

How to enable tcp/ip protocol on a sql server?

1219

What is the use of sign function?

1201

Explain about integration services of Microsoft SQL server?

1093

Introduction of rollup clause using sum and group by clause?

1022

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