Review

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."

  1. What three operations do transaction logs support?
  2. What events are recorded in a transaction log?
  3. When are checkpoints created in a transaction log?
  4. When does log truncation occur?
  5. What is a transaction?
  6. What three types of transactions does SQL Server support, and how do they differ?
  7. What Transact-SQL statement is used to mark the starting point of an explicit transaction?
  8. What two phases are used to manage the commit process in the distributed transaction?
  9. What are the differences between lost updates and uncommitted dependencies?
  10. What are the differences between optimistic concurrency and pessimistic concurrency?
  11. What isolation levels does SQL Server support?
  12. What guidelines should you follow to help minimize deadlocks?


Microsoft Press Staff - MCSE. Microsoft SQL Server 2000 Database Design and Implementation Training Kit
MCSE Training Kit (Exam 70-229): Microsoft SQL Server(TM) 2000 Database Design and Implementation (Pro Certification)
ISBN: 073561248X
EAN: 2147483647
Year: 2001
Pages: 97

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net