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 different types of statements that are supported by sql?

1101

Characterize join and name diverse sorts of joins?

1026

Why would you use sql agent?

1349

What are the different types of backups avaialabe in sql server 2005?

1066

What is set nocount on?

998

What are the different types of upgrades that can be performed in sql server?

1219

What does null mean?

1054

What is the difference between truncate and delete commands?

1111

What is normalization? What number of normalization shapes are there?

1163

What is collation?

1197

What are the operating modes in which database mirroring runs?

1142

Define self join?

1080

Does transparent data encryption provide encryption when transmitting data across the network?

1101

What are transactions and its controls?

1109

What is the cartesian product of table?

1073

Un-Answered Questions { SQL Server }

Can an entity have two primary keys?

1033

Does index speed up select statements?

1079

Explain about merge replications?

1084

What are the 7 disadvantages to a manual system?

1037

What is lock escalation and what is its purpose?

1031

What are constraints?

1064

What is sql stored procedure?

1150

What are relationships and mention different types of relationships in the dbms

1020

How do I make a resultset scrollable?

1016

What xml support does the sql server extend?

1060

How to delete a database in ms sql server?

1327

What is history table in sql server?

1040

What are the different subsets of sql?

1624

how many layers of tcp/ip protocol combined of? : Sql server database administration

1054

Name few of the dcl commands in sql?

1057

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