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,

2485

Rate yourself in .NET and SQL ?

Cognizant, HCL, SunGard,

1 9068

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 10605

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

Credit Suisse, GCU, Symphony, TCS,

4 27436

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

4 8774

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

1 8230

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

1 4897

Define candidate key, alternate key, composite key.

Infosys, Software India,

13 116572

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

TCS,

2 9122

What is a transaction and what are ACID properties?

Config Systems, IBM, TCS, Virtusa,

14 78673

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

3 8965

Explain Active/Active and Active/Passive cluster configurations

2 16013

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

Wipro,

8 30969

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

Microsoft,

7 48238

What is blocking and how would you troubleshoot it?

2 5651

Un-Answered Questions { SQL Server }

Can you index views?

946

What are wait types?

1219

What is the difference between for xml raw and for xml auto?

1095

Disadvantages of the indexes?

1205

Can sql servers link to other servers like oracle?

900

What is sql server query analyzer?

1111

Can we do dml on views?

1024

What is self contained sub query?

1129

What is acid mean in sql server?

1218

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

1479

What are different types of constraints?

981

How to provide default values to function parameters?

1235

How to convert character strings into numeric values?

1167

What are the different SQL Server Versions you have worked on?

1071

Why use identity in sql server?

1185

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