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?

1046

Tell me what are cursors and when they are useful?

993

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

1067

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

1147

Tell me when is the update_statistics command used?

1198

Explain the xml support sql server extends?

1080

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

1022

Do you know what is rank function?

1125

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

1072

Do you know what are acid properties?

1122

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

1017

Explain what is public role in sql server?

1189

Do you know how to send email from database?

1045

Explain what is analysis service repository?

1047

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

991

Un-Answered Questions { SQL Server }

What is user-defined function? Explain its types i.e. Scalar and inline table value user-defined function?

937

What is built-in/administrator?

1073

What language is sql server written in?

1079

What are ddl triggers and types of ddl trigger?

1092

Which are the third-party tools used in sql server and why would you use them?

959

What are the tool windows in sql server management studio? : sql server management studio

1121

explain extended properties

1036

What is an indexing strategy?

1064

How to how to convert numeric expression data types using the convert() function??

1092

Mention what are the core components of ssrs?

330

in the physical file layout, where should the transaction log be stored in relation to the data file?

1039

What the difference between UNION and UNIONALL?

1086

Explain the use of containers in ssis and also their types?

1016

How to create prepared statements using odbc_prepare()?

1101

Explain primary key and foreign key constraints?

1089

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