|
- 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 ?
- can you explain the star schema for OLAP ?
- What is DTS?
- What is fillfactor ?
- 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 ?
- 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 ?
- What’s the difference between Stored Procedure (SP) and User Defined Function (UDF)?
|
microsoft bi suite