1. What is Transaction?
2. What is Dead Lock?
3. What is a Live Lock?
4. What is Isolation Level?
5. What is a NOLOCK?
6. Can we check locks in database? If so, how can we do this lock check?
7. What is lock escalation?
8. What is a deadlock and what is a live lock? How will you go about resolving deadlocks?
9. What is blocking and How would ou troubleshoot it?
10. What are statistics, under what circumstances they go our of date, how do you update them?
11. What are locks?
12. What are the different types of locks?
13. For example, if the transaction isolation level is set to SERIALIZABLE, and the table-level locking hint NOLOCK is used with the SELECT statement , key-range locks typically used to maintain serializable transactions are not taken?
14. After one Begin Transaction a truncate statement and Roll Back statements ar ether. Will it be roll backed? Since the truncate statement does not perform logged operation how does it Rollback?
15. What is the value of @@Row count at each statement levels?
16. What is Uncommitted Dependency (Dirty Read)?
17. What is Inconsistent Analysis (Non Repeatable Read)?
18. What is Phantom Reads?
19. What is @@ Tran count?
20 Can you have a nested transaction?
21.What is Isolation Level?
22. What is the difference between the REPEATABLE READ and SERIALIZE isolation levels?
23. What is the difference between COMMIT and ROLLBACK?
2. What is Dead Lock?
3. What is a Live Lock?
4. What is Isolation Level?
5. What is a NOLOCK?
6. Can we check locks in database? If so, how can we do this lock check?
7. What is lock escalation?
8. What is a deadlock and what is a live lock? How will you go about resolving deadlocks?
9. What is blocking and How would ou troubleshoot it?
10. What are statistics, under what circumstances they go our of date, how do you update them?
11. What are locks?
12. What are the different types of locks?
13. For example, if the transaction isolation level is set to SERIALIZABLE, and the table-level locking hint NOLOCK is used with the SELECT statement , key-range locks typically used to maintain serializable transactions are not taken?
14. After one Begin Transaction a truncate statement and Roll Back statements ar ether. Will it be roll backed? Since the truncate statement does not perform logged operation how does it Rollback?
15. What is the value of @@Row count at each statement levels?
16. What is Uncommitted Dependency (Dirty Read)?
17. What is Inconsistent Analysis (Non Repeatable Read)?
18. What is Phantom Reads?
19. What is @@ Tran count?
20 Can you have a nested transaction?
21.What is Isolation Level?
22. What is the difference between the REPEATABLE READ and SERIALIZE isolation levels?
23. What is the difference between COMMIT and ROLLBACK?
No comments:
Post a Comment