3 4
The following questions are intended to reinforce key information presented in this chapter. If you are unable to answer a question, review the appropriate lesson and then try the question again. You can find answers to the questions in Appendix A, "Questions and Answers."
- What three operations do transaction logs support?
- What events are recorded in a transaction log?
- When are checkpoints created in a transaction log?
- When does log truncation occur?
- What is a transaction?
- What three types of transactions does SQL Server support, and how do they differ?
- What Transact-SQL statement is used to mark the starting point of an explicit transaction?
- What two phases are used to manage the commit process in the distributed transaction?
- What are the differences between lost updates and uncommitted dependencies?
- What are the differences between optimistic concurrency and pessimistic concurrency?
- What isolation levels does SQL Server support?
- What guidelines should you follow to help minimize deadlocks?