SQL Server Interview Questions

home
database
view story

2 Kicks

SQL Server Interview Questions(sqltrends.blogspot.com)

submitted by sagitariusmzi(123) 2 years, 9 months ago

How to implement many-to-many relationships? What's the difference between a primary key and a unique key? What is user defined datatypes and when to use them? Define candidate key, alternate key, and composite key? Is there a column to which a default value can't be bound? What are ACID properties? Explain different isolation levels? What is MOLAP, ROLAP and HOLAP? Types of constraints? What are the types of indexes ? What are the type of the NonClustered Indexes ? In which situation NonClustered is more fast then clustered index? What is the difference between deadlock , live lock and blocking ? And How to resolve them? What are the Query Hints?

add a comment |category: Database |Views: 71
Tweet