SQL Server Interview Questions
Questions Answers Views Company eMail

How do you optimize Sql queries ?

Cognizant,

1180

Rate yourself in .NET and SQL ?

SunGard, HCL, Cognizant,

1 5661

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 5505




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

Symphony, TCS, Credit Suisse, GCU,

4 21154

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

4 5127

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

1 6119

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

1 3060

Define candidate key, alternate key, composite key.

Infosys, Software India,

13 104914




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

TCS,

2 5587

What is a transaction and what are ACID properties?

Virtusa, TCS, IBM, Config Systems,

14 63644

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

3 5619

Explain Active/Active and Active/Passive cluster configurations

2 13213

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

Wipro,

8 23019

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

Microsoft,

7 40131

What is blocking and how would you troubleshoot it?

2 3260


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.

705


Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?

1300


How do you Implement SSIS Packages in your Project?

834


in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it

313


tell me the disaster recovery plan

1285






Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you

595


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

969


How to trouble shoot if unable to connect SQL Server

766


query processing

1000


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

920


how to use DTS package in 2000,2005,2008 in sql server

779


How to restore performance issues and how to check?

844


How do use Having,Group by,Group function in SQL?

671


1 01 101 01010

742


what is difference between view and Dip.

1206