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

What are xml indexes?

952

What is the openxml statement in sql server?

1072

Explain indexed view?

1 1439

What is for xml in sql server?

1074

How to call stored procedure using http soap?

1079

Can you explain what is indexed view? How to create it?

904

Explain what are partitioned views and distributed partitioned views?

943

Do you know what are the restrictions that views have to follow?

1079

What are secondary xml indexes?

1026

What are the disadvantages of merge replication?

1424

What is replication and database mirroring?

1047

What is shared lock?

901

Explain the advantages of merge replication?

952

Explain hostprotectionattribute in sql server 2005?

1028

What is exclusive locks?

957

Un-Answered Questions { SQL Server }

What are the 7 disadvantages to a manual system?

983

What is a document index?

1028

Explain about remote stored procedure?

1008

What is unique key constraint?

1060

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

983

What are the basic features of a trigger in ms sql server?

1193

What are the essential components of sql server service broker?

1019

How many levels of sp nesting is possible?

1056

In what three ways is the return statement used in a stored procedure?

1008

how to create a scrollable cursor with the scroll option? : Sql server database administration

1092

Why are sql functions used?

1119

What do you mean by an execution plan? How would you view it?

914

How to create new table with "create table" statements?

1109

Which sql server is best?

992

Explain database normalization?

1225

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