Wednesday, August 5, 2009

SQL Server Interview Questions


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?
What are the different types of DBCC commands?
What are instead of triggers and what’s the difference between Insert and Instead of trigger , which trigger will be fired first ?
What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors? Why DBAs don’t like Cursors ?
What is a self join? Is self join physically exists in Sql Server ?
What is the difference between OSQL and Query Analyzer ?
What is BCP and when to use it ?
What is collation ?
What’s the difference between a primary key and a unique key?
When is the use of UPDATE_STATISTICS command?
What types of Joins are possible in Sql Server?
Where are SQL server users names and passwords are stored in sql server?
What is log shipping?
What is the difference between a local and a global variable?
What are the OS services that the SQL Server installation adds?
Specify  3 ways to get an accurate count of the number of records in a table?
What is the basic functions for master, msdb, model, tempdb databases?
What is a table called, if it does not have neither Cluster nor Non-cluster Index? What is it used for?
How do you load large data to the SQL server database?
What is Cross Join?
What is OLTP(OnLine Transaction Processing)? How to define that a Database is OLTP ?
What is the Diffrence between Extents and Page
What is the Diffrence between temp table and table variable
What is SQL injection
Specify the Tips when Optimizing Sql Server 2005 Query
What is the difference between UNION ALL Statement and UNION
What are the different types of Locks
What is Write ahead log?
How to get which Process is Blocked in SQL SERVER
What is SQL Server English Query?
What is XPath?
What is the STUFF and how does it differ from the REPLACE function?

5 comments:

  1. Good collection of Interview Questions

    http://www.aired.in/search/label/Interview-Questions

    ReplyDelete
  2. Hi

    I like this post:

    You create good material for community.

    Please keep posting.

    Let me introduce other material that may be good for net community.

    Source: Database interview questions

    Best rgs
    Peter

    ReplyDelete
  3. Hi

    I read this post 2 times. It is very useful.

    Pls try to keep posting.

    Let me show other source that may be good for community.

    Source: Database interview questions

    Best regards
    Jonathan.

    ReplyDelete
  4. Collection is good if i found answers also

    ReplyDelete
  5. Hi

    I read this post two times.

    I like it so much, please try to keep posting.

    Let me introduce other material that may be good for our community.

    Source: Database interview questions

    Best regards
    Henry

    ReplyDelete

Share This