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?

1001

Tell me what are cursors and when they are useful?

957

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

1032

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

1099

Tell me when is the update_statistics command used?

1119

Explain the xml support sql server extends?

1045

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

994

Do you know what is rank function?

1081

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

1033

Do you know what are acid properties?

1086

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

979

Explain what is public role in sql server?

1140

Do you know how to send email from database?

1013

Explain what is analysis service repository?

1006

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

944

Un-Answered Questions { SQL Server }

What is transact-sql ddl trigger?

1113

What is a transaction and why is it important?

1094

Explain what are various ways to enhance the ssrs report?

1046

How do I view views in sql server?

1014

What is autocommit mode in sql server?

1187

Equi join and non equi join is possible with sql server?

1027

What are the requirements to use odbc connections in php scripts?

1122

What is use of except clause?

1093

How to insert data with null values?

1039

How do you create type- insensitive operator?

1048

What are Spatial data types in SQL Server 2008

1027

What is a dataset and what are the different types of datasets?

136

How many types of built in functions are there in sql server 2012?

926

Explain the difference between functions and stored procedures in sql server?

985

List types of tables in SQL Azure?

126

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