SQL SERVER Interview Questions and Answers
- What is normalization?
- What are different types of normalization?
- What is denormalization?
- How can you increase SQL performance?
- What is the difference between DELETE and TRUNCATE TABLE?
- Can we suggest locking hints to SQL SERVER?
- What is the difference between UNION and UNION ALL SQL syntax?
- What is the purpose of Replication?
- If we have multiple AFTER Triggers , can we specify sequence ?
- What are the different types of joins?
- What is DTS?
- If locking is not implemented, what issues can occur?
- What is LOCK escalation?
- How can you raise custom errors from stored procedure?
- What are the different types of replication supported by SQL SERVER?
- What is SQL injection?
- What is a candidate key?
- What is fill factor ?
- What are different transaction levels in SQL SERVER?
- What are the different ways of moving data between databases in SQL Server?
- What is ACID fundamental?
- What is BCP utility in SQL SERVER?
- What is the difference between Stored Procedure and User Defined Function?
- What are indexes and what is the difference between clustered and nonclustered?
- What is RAID and how does it work?
- What are the different locks in SQL SERVER?
- What is the difference between a HAVING CLAUSE and a WHERE CLAUSE?
- What is DBCC?
- What are the different types of triggers in SQl SERVER?
