SQL Server Interview Questions
Questions Answers Views Company eMail

How do you optimize Sql queries ?

Cognizant,

1227

Rate yourself in .NET and SQL ?

Cognizant, HCL, SunGard,

1 5793

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 5643




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

Symphony, TCS, Credit Suisse, GCU,

4 21566

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

4 5220

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

1 6198

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

1 3124

Define candidate key, alternate key, composite key.

Infosys, Software India,

13 105273




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

TCS,

2 5736

What is a transaction and what are ACID properties?

IBM, TCS, Virtusa, Config Systems,

14 64278

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

3 5785

Explain Active/Active and Active/Passive cluster configurations

2 13328

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

Wipro,

8 23370

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

Microsoft,

7 40597

What is blocking and how would you troubleshoot it?

2 3349


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

How we create SQL Server 2005 Reporting Services ? Give me Sample

970


System variable and temporary variables

1036


How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?

987


Explain Capacity planning to create a database? and how to monitor it?

2918


Why do you want to join software field as you have done your BE in Electronics?

1076






code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that

1106


How to trouble shoot if unable to connect SQL Server

832


tell me the disaster recovery plan

1349


Issues related in upgrading SQL Server 2000 to 2005 / 2008

841


What is best institute to Learn DotNET And SQL in chennai?

1029


Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .

897


what is package and it uses and how can u call a package

948


whats the maximum size of view state??

1005


New concepts of sql server 2005 use in your project.

1289


IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do

716