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.

874

Explain indexed views and partitioned view with their syntax.

1084

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

906

What is difference between stored procedure and user defined function?

1033

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

915

What’s the use of custom fields in report?

894

What is the function of sql server agent windows service?

1032

What are different types of replication in sql server?

1038

Explain partitioned view?

1025

Describe in brief databases and sql server databases architecture.

948

What are commit and rollback in sql?

1058

How many levels of sp nesting are possible?

964

How to provide login information for a new odbc dsn?

985

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

984

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

1049

Un-Answered Questions { SQL Server }

what's sql server? : Sql server database administration

934

What is a linked server in sql server?

1017

What is TDS(Tabular Data Stream) Gateway?

121

What is identity?

952

What is difference statement and preparedstatement?

937

Explain the stored procedure?

994

Are semicolons required at the end of sql statements in sql server 2005?

934

What are the key configuration files for sql server reporting services ?

163

Explain filtered indexes?

935

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?

1091

Explain cdc and sql injection?

917

You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?

1057

What is de-normalization and what are some of the examples of it?

928

What is difference between views and stored procedures?

932

What do you understand by intent locks?

958

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