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.

967

Explain indexed views and partitioned view with their syntax.

1190

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

1007

What is difference between stored procedure and user defined function?

1168

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

994

What’s the use of custom fields in report?

986

What is the function of sql server agent windows service?

1143

What are different types of replication in sql server?

1142

Explain partitioned view?

1131

Describe in brief databases and sql server databases architecture.

1063

What are commit and rollback in sql?

1168

How many levels of sp nesting are possible?

1067

How to provide login information for a new odbc dsn?

1094

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

1090

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

1208

Un-Answered Questions { SQL Server }

Explain logical operators in sql server?

1180

What is page-level compression?

1009

Can select statements be used on views in ms sql server?

1105

State the difference between local and global temporary tables?

1166

Can a unique index be created on a column, which contains null?

966

What is data source document?

1087

What are data files?

1091

What is change data capture (cdc) in sql server 2008?

1078

What are pessimistic lock and optimistic lock?

1138

Tell me what is fill factor?

1009

Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?

1030

What are the system database in sql server 2005?

1096

What is usually the first word in a sql query?

1172

List the data types available in mssql?

1101

Every night you run a full backup after every 3 three hours you make a differential backup every hour you make an incremental backup in a worst-case scenario, how much work you can lose?

1001

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