Day 7
Quiz
| 1: | What does the acronym ACID stand for and what is it used for? |
| A1: | ACID stands for Atomicity, Consistency, Isolation, and Durability. ACID is used to define the characteristics all transactions must satisfy to be considered a transaction. |
| 2: | How do you define an explicit, local transaction using Transact-SQL? How do you define an explicit, distributed transaction using Transact-SQL? |
| A2: | Use the BEGIN TRANSACTION statement for local transactions and the BEGIN DISTRIBUTED TRANSACTION statement for distributed transactions . |
| 3: | What does the durability property of a transaction mean? |
| A3: | The database must preserve the effects of all committed transactions as well as database consistency in the case of system or media failures. The ... |
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.
