لطفا منتظر باشید ...
Review
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 the Appendix, '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?
