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 number sorts of privileges are accessible in sql?

1031

What are the difference between primary keys and foreign keys?

963

Define normalisation?

1106

How can you control the amount of free space in your index pages?

1055

What is sql sandbox in sql server?

1214

What is dbcc?

1131

How to delete exactly duplicate records from a table?

1061

What is the contrast amongst drop and truncate?

1032

What are data files?

1034

What is the difference between a clustered index and a non-clustered index?

986

What are the difference between clustered and a non-clustered index?

1038

On a windows server 2003 active – passive failover cluster, how do you find the node which is active?

1204

What is the use of nvl work?

994

How to optimize stored procedures in sql server?

1182

What is the difference between the 2 operating modes of database mirroring?

1105

Un-Answered Questions { SQL Server }

Is it true that rules do not apply to data already existing in a database at the time the rule is created?

1035

What happens if null values are involved in arithmetic operations?

1006

How to create a simple table to test triggers in ms sql server?

972

What does nvl stand for?

939

Why use triggers?

1009

What is nested transaction?

1091

What is Replication?

1040

What is advantage data architect?

920

what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?

5921

What is the synonym of join?

956

Explain optimistic and pessimistic concurrency?

991

Delete duplicate rows without using rowid.

1532

How many replicas are maintained for each sql azure db?

124

What is a join in sql?

1082

Explain multiserver query

1035

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