Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...



SQL Server Interview Questions
Questions Answers Views Company eMail

How do you optimize Sql queries ?

Cognizant,

1475

Rate yourself in .NET and SQL ?

Cognizant, HCL, SunGard,

1 6525

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 6440

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

Credit Suisse, GCU, Symphony, TCS,

4 23347

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

4 5778

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

1 6579

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

1 3438

Define candidate key, alternate key, composite key.

Infosys, Software India,

13 107193

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

TCS,

2 6421

What is a transaction and what are ACID properties?

Config Systems, IBM, TCS, Virtusa,

14 67380

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

3 6470

Explain Active/Active and Active/Passive cluster configurations

2 13803

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

Wipro,

8 24990

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

Microsoft,

7 42619

What is blocking and how would you troubleshoot it?

2 3780







Un-Answered Questions { SQL Server }

What is merge replication?

136


According to you what goes into making the best database administrator? : sql server database administration

138


How many replicas are maintained for each SQL Azure database?

60


What is difference between joins and subqueries?

104


Can I delete event logs?

119






what happens on checkpoint? : Sql server database administration

130


What is a linked server in sql server?

149


Explain the various types of concurrency problem?

151


Explain optimistic and pessimistic concurrency?

127


How to modify the underlying query of an existing view?

127


Do you know what is difference between index seek vs. Index scan?

145


What is the difference between mysql and mysqli?

179


What is the purpose of sql profiler in sql server? : sql server database administration

173


What is check constraint in sql server?

130


What is key attribute?

103