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

How do you optimize Sql queries ?

Cognizant,

2480

Rate yourself in .NET and SQL ?

Cognizant, HCL, SunGard,

1 9057

in tabase table having a column in it empname field is there which having 5 duplicate values is there i want deleted all the duplicates i want showing only one name only.

7 10568

How do you implement one-to-one, one-to-many and many-to- many relationships while designing tables?

Credit Suisse, GCU, Symphony, TCS,

4 27413

What's the difference between a primary key and a unique key?

4 8765

What are user defined datatypes and when you should go for them?

1 8227

What is bit datatype and what's the information that can be stored inside a bit column?

1 4894

Define candidate key, alternate key, composite key.

Infosys, Software India,

13 116529

What are defaults? Is there a column to which a default can't be bound?

TCS,

2 9108

What is a transaction and what are ACID properties?

Config Systems, IBM, TCS, Virtusa,

14 78576

Create Index myIndex On myTable(myColumn) What type of Index will get created after executing the above statement

3 8951

Explain Active/Active and Active/Passive cluster configurations

2 15985

What is RAID and what are different types of RAID configurations?

Wipro,

8 30916

What is a deadlock and what is a live lock? How will you go about resolving deadlocks?

Microsoft,

7 48205

What is blocking and how would you troubleshoot it?

2 5643

Un-Answered Questions { SQL Server }

Define indexes?

1098

What is report snapshot in ssrs?

280

How do I find the sql server version?

1086

Explain important index characteristics?

1083

Tell me what is de-normalization and what are some of the examples of it?

1104

What are the events recorded in a transaction log?

1052

How can you find out how many rows returned in a cursor?

1090

How to use “drop” keyword in sql server and give an example?

1197

How can we delete Duplicate row in table?

1117

Explain security with sql azure?

186

What do you know about system database? : SQL Server Architecture

1045

Can we use where and having clause together?

1106

What is the difference between value type and reference type?

992

What is scan table/view and seek table/view when its occurs? : sql server database administration

1103

How do you delete duplicate records in sql server?

1129

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