SQL Server Interview Questions

By | April 28, 2014

What is normalization?

What are different type of normalization?

What is denormalization ?

What is a candidate key ?

What are different types of joins and whats the difference between them ?

What are indexes and What is the difference between clustered and nonclustered indexes?

How can you increase SQL performance ?

What is the use of OLAP ?

What’s a measure in OLAP ?

What are dimensions in OLAP ?

What are levels in dimensions ?

What are fact tables and dimension tables in OLAP ?

(Twist :- can you explain the star schema for OLAP ? )

What is DTS?

What is fillfactor ?

(Twist :- When does plage split occurs ?)

What is RAID and how does it work ?

What’s the difference between DELETE TABLE and TRUNCATE TABLE commands?

What are the problems that can occur if you do not implement locking properly in SQL SERVER ?

What are different transaction levels in SQL SERVER ?

(Twist :- what are different types of locks in SQL SERVER ?)

What are different locks in SQL SERVER ?

Can we suggest locking hints to SQL SERVER ?

What is LOCK escalation?

What are the different ways of moving data/databases between servers and databases in SQL Server?

What are advantages of SQL 2000 over SQl 7.0 ?

What is the difference between a HAVING CLAUSE and a WHERE CLAUSE?

What is difference between UNION and UNION ALL SQL syntax ?

How can you raise custom errors from stored procedure ?

What is ACID fundamental and what are transactions in SQL SERVER ?

What is DBCC?

What is purpose of Replication ?

What are different type of replication supported by SQL SERVER ?

What is BCP utility in SQL SERVER ?

What are different types of triggers in SQl SERVER 2000 ?

If we have multiple AFTER Triggers on table how can we define the sequence of the triggers ?

What is SQl injection ? ===============================================================================================

Leave a Reply