SQL SERVER INTERVIEW QUESTIONS
What is a candidate key ?What are the different types of joins? What is the difference between them ?
What are indexes? What is the difference between clustered and nonclustered indexes?
How can you increase SQL performance ?
What is the use of OLAP ?
What is 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 page split occurs ?
What is 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 the 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 ?
What is the difference between a HAVING CLAUSE and a WHERE CLAUSE?
What is the difference between UNION and UNION ALL SQL syntax ?
How can you raise custom errors from stored procedure ?
What is ACID fundamental? What are transactions in SQL SERVER ?
What is the purpose of Replication ?
What are the different types of replication supported by SQL SERVER ?
What’s difference between “Optimistic” and “Pessimistic” locking ?
What is normalization?
What are different types of normalization?
What is denormalization ?
What is BCP utility in SQL SERVER ?
What are the different types of triggers in SQl SERVER ?
If we have multiple AFTER Triggers on table how can we define the sequence of the triggers ?
What is the difference between Stored Procedure (SP) and User Defined Function (UDF)?