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,

2426

Rate yourself in .NET and SQL ?

Cognizant, HCL, SunGard,

1 8966

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 10304

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

Credit Suisse, GCU, Symphony, TCS,

4 27253

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

4 8579

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

1 8142

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

1 4803

Define candidate key, alternate key, composite key.

Infosys, Software India,

13 116011

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

TCS,

2 8980

What is a transaction and what are ACID properties?

Config Systems, IBM, TCS, Virtusa,

14 78063

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

3 8804

Explain Active/Active and Active/Passive cluster configurations

2 15893

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

Wipro,

8 30559

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

Microsoft,

7 47971

What is blocking and how would you troubleshoot it?

2 5521

Un-Answered Questions { SQL Server }

How to execute stored procedure and set temp table in sql server?

1040

What are the common performance issues in sql server?

928

What does null mean?

984

What are drillthrough reports?

155

How to write character string constants or literals in ms sql server?

1019

What is the use of tempdb? What values does it hold?

1072

How do you migrate data from mssql server to azure?

165

Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?

1075

What is clustered primary key?

1026

Why should one not prefix user stored procedures with ‘sp_’?

1046

Do you know clustered and non-clustered index?

979

What are the steps to follow to configure SQL*Net?

1042

How do clustered indexes store data?

1106

What does normalization do to data?

1067

What is an indexing strategy?

1010

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