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,

2353

Rate yourself in .NET and SQL ?

Cognizant, HCL, SunGard,

1 8870

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 10100

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

Credit Suisse, GCU, Symphony, TCS,

4 27105

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

4 8408

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

1 8075

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

1 4733

Define candidate key, alternate key, composite key.

Infosys, Software India,

13 115624

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

TCS,

2 8862

What is a transaction and what are ACID properties?

Config Systems, IBM, TCS, Virtusa,

14 77454

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

3 8672

Explain Active/Active and Active/Passive cluster configurations

2 15790

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

Wipro,

8 30220

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

Microsoft,

7 47751

What is blocking and how would you troubleshoot it?

2 5406

Un-Answered Questions { SQL Server }

What is ms sql server service broker?

937

what is normalization? : Sql server database administration

1028

How important do you consider cursors or while loops for a transactional database?

920

How to delete a login name in ms sql server?

1013

What are four major operators that can be used to combine conditions on a where clause?

997

What is database mirroring?

1054

What are the different Authentication modes in SQL Server and how can you change authentication mode?

1036

What are the advantages of user-defined functions over stored procedures in sql server?

980

Give main differences between "Truncate" and "Delete".

1039

how can u get last observation in an unknown dataset ?

2395

Explain sub-query?

907

If user is owning any SQL Objects, can we drop that user

2020

How do I start sql server agent automatically?

923

Write a SQL query to delete a table?

1088

What specific conditions database should meet, before you can bulk copy data into it using bcp?

949

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