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 is a join in sql?

1092

Why use update_statistics command in sql server?

1052

List out the difference between union and union all in sql server?

990

What are locks in sql?

980

In what sequence sql statement is processed?

1012

Explain how many types of relationship?

1029

What is de-normalization in sql database administration? Give examples?

984

List the different types of collation sensitivities in sql server?

1044

Why use cursor in sql server?

1077

Write the syntax for stuff function in an sql server?

1027

What does man by sql wildcard characters in sql server?

1059

Explain about unique identifier data type in sql server?

917

List all types of constraints in sql server?

1042

What are views used for?

1014

What are constraints?

1010

Un-Answered Questions { SQL Server }

What is replication with database mirroring? : sql server database administration

1076

What is data block and how to define data block size?

1026

What are the High-Availability solutions in SQL Server and differentiate them briefly?

1146

What is difference between index seek vs. Index scan?

1155

What are the purposes of floor and sign functions?

976

What is model database? : SQL Server Architecture

1130

Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?

1189

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

1004

What is the difference between delete and truncate statements?

1083

What is 1nf 2nf and 3nf?

891

what happens on checkpoint? : Sql server database administration

1102

How secure is sql server database?

1008

What kind of problems occurs if we do not implement proper locking strategy?

1404

Who developed sql server?

939

plss anybody specify tha constrian management system in dbms

2151

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