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?

1038

Characterize join and name diverse sorts of joins?

965

Why would you use sql agent?

1256

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

1013

What is set nocount on?

935

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

1175

What does null mean?

980

What is the difference between truncate and delete commands?

1062

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

1104

What is collation?

1136

What are the operating modes in which database mirroring runs?

1082

Define self join?

1023

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

1033

What are transactions and its controls?

1054

What is the cartesian product of table?

1005

Un-Answered Questions { SQL Server }

what do you understand by change data capture?

999

Explain what is raid and what are different types of raid levels?

1018

How to set the current database in ms sql server?

1073

What is SubQuery in SQL Server 2008

1017

What is xdr?

985

Explain logical operators in sql server?

1105

What is the difference between varchar and nvarchar?

939

How to insert data with null values?

1018

Does a server store data?

920

What is server-level principal?

122

Do you know the policy based administration feature of sql server 2008?

953

What are the differences between decimal and float in ms sql server?

1236

Define candidate key, alternate key, and composite key.

920

What is full outer join in sql server joins?

1061

Explain the cursor lock types?

1047

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