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 the advantages of paper records?

915

What is the difference between sdf and mdf?

1250

What is acid db?

850

How do I find my localdb version?

946

What are the 7 disadvantages to a manual system?

924

What is a dbms wizard?

976

What is advantage data architect?

874

What is field in algebra?

987

What is a field name?

924

Where is localdb stored?

892

How do I know if localdb is running?

905

What does normalization do to data?

1001

What are the five characteristics of good data?

879

What is data file in computer?

902

Why is normalisation important?

909

Un-Answered Questions { SQL Server }

What are the advantages of stored procedure in sql server?

845

Explain about nested stored procedure?

986

What is dbcc? Give few examples.

966

Is BCNF better than 2NF & 3NF? Why?

1013

What is the difference between for xml raw and for xml auto?

991

What are the dmvs?

959

What is resource governor in sql server?

954

Give an example of why you would want to denormalize a database

941

Do you know what are the restrictions applicable while creating views? : SQL Server Architecture

958

What is self contained scalar sub query?

937

What command would you use to create an index?

992

What is a self join in sql server?

1072

Tell me what is difference between view and materialized view?

895

What is collation?

1103

How to find Duplicate Records In table?

972

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