Workshop

The Workshop provides quiz questions to help you solidify your understanding of the material covered and exercises to provide you with experience in using what you've learned. Try to understand the quiz and exercise answers before continuing to the next lesson. Answers are provided in Appendix A.

Quiz

1:What does the acronym ACID stand for and what is it used for?
2:How do you define an explicit, local transaction using Transact-SQL? How do you define an explicit, distributed transaction using Transact-SQL?
3:What does the durability property of a transaction mean?
4:What are some of the ways you can improve the performance of your transactions?
5:What role does the MS DTC assume in distributed transactions?

Exercises

1:Using Transact-SQL, ...

Get Sams Teach Yourself Microsoft® Windows® DNA Programming in 21 Days now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.