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,

2411

Rate yourself in .NET and SQL ?

Cognizant, HCL, SunGard,

1 8951

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 10273

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

Credit Suisse, GCU, Symphony, TCS,

4 27235

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

4 8549

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

1 8135

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

1 4789

Define candidate key, alternate key, composite key.

Infosys, Software India,

13 115942

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

TCS,

2 8966

What is a transaction and what are ACID properties?

Config Systems, IBM, TCS, Virtusa,

14 77973

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

3 8779

Explain Active/Active and Active/Passive cluster configurations

2 15879

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

Wipro,

8 30494

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

Microsoft,

7 47954

What is blocking and how would you troubleshoot it?

2 5512

Un-Answered Questions { SQL Server }

What is sql server query analyzer?

1019

Can we linked SharePoint to a SQL database?

1017

What happens if time-only values are provided as date and time literals?

1004

How many types of schemas are there?

1036

Do you know what is user defined datatypes and when you should go for them?

960

What is collation sensitivity?

1053

How to check if a table is being used in sql server?

959

What is difference in performance between insert top (n) into table and using top with insert?

1035

How to throw custom exception in Stored Procedure?

1040

How do you start single user mode in clustered installations?

934

can you implement data mining in SSRS?

148

What are the requirements for sql server 2016?

878

Can we call stored procedure in view in sql server?

891

What is a with(nolock)?

978

what is create database syntax? : Sql server database administration

1099

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