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

Define candidate key, alternate key, and composite key.

922

Explain indexed views and partitioned view with their syntax.

1146

Difference between report and query parameter. Why do we need different type of parameter?

953

What is difference between stored procedure and user defined function?

1104

You want to implement the one-to-many relationship while designing tables. How would you do it?

960

What’s the use of custom fields in report?

944

What is the function of sql server agent windows service?

1096

What are different types of replication in sql server?

1084

Explain partitioned view?

1069

Describe in brief databases and sql server databases architecture.

1008

What are commit and rollback in sql?

1123

How many levels of sp nesting are possible?

1024

How to provide login information for a new odbc dsn?

1052

How to declare a cursor with "declare ... Cursor" in ms sql server?

1046

How to define and use table alias names in ms sql server?

1132

Un-Answered Questions { SQL Server }

Please differentiate between a local and a global temporary table?

1007

What is table value parameters (tvp)?

1101

What is a trace frag? Where do we use it?

1100

What are dml (data manipulation language) statements in ms sql server?

983

What are commit and rollback in sql?

1123

Detail about query optimizer?

1103

Explain the difference between clustered and non-clustered index?

923

What is a group function explain with an example?

988

What are different types of join?

1315

What are rest-style architecture's?

170

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

1024

Can we check locks in database? If so, how can we do this lock check?

942

What do you understand by recursive stored procedures?

988

What are the purpose of Normalisation?

1050

How to list all login names on the ms sql server?

1142

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