SQL Server Interview Questions
Questions Answers Views Company eMail

How do you optimize Sql queries ?

Cognizant,

1191

Rate yourself in .NET and SQL ?

SunGard, HCL, Cognizant,

1 5699

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 5543




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

Symphony, TCS, Credit Suisse, GCU,

4 21276

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

4 5153

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

1 6143

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

1 3076

Define candidate key, alternate key, composite key.

Infosys, Software India,

13 105016




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

TCS,

2 5634

What is a transaction and what are ACID properties?

Virtusa, TCS, IBM, Config Systems,

14 63814

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

3 5672

Explain Active/Active and Active/Passive cluster configurations

2 13244

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

Wipro,

8 23125

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

Microsoft,

7 40272

What is blocking and how would you troubleshoot it?

2 3286


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

how can you attach more than 20 ldf files in sql server

846


I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible

1122


System variable and temporary variables

994


How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?

1275


what is the sql equivaent of the dataset relation object ?

855






How much memory that we are using in Logshipping Concept?

724


What is the difference between NOROW and LOCKROW?

1318


what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?

4791


In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram

822


where the connection string store in the database

832


my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions

890


explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?

1282


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

950


1 01 101 01010

766


Comment,Datatypes are unlimited

936