Which of the following scenarios reflects the durability property? 1. A fairly large update is made to the products table. 2. The update is saved to the logs. 3. The update starts to then save to the disk. 4. The system fails midway through. 5. When the system starts back up, the committed transactions that haven't been written to disk are written. 1. The product quantity starts at 200. 2. Transaction 1 runs to read the quantity of the product to be updated. 3. Transaction 2 runs in parallel to read the quantity of the product to be updated. 4. Transaction 1 updates the product quantity to reduce it by 100. 5. Transaction 2 updates the product quantity to reduce it by 5. 6. The product quantity ends at 195. 1. Transaction 1 reads a product's cost which is set at $100. 2. Transaction 1 updates the product to set the price to $90. 3. Transaction 2 reads the same product's cost and sees $100. 4. Transaction 1 commits the cost. 5. Transaction 3 reads the same product's cost and sees $90. 1. User 1 has $500 in their online account. 2. User 2 has $300 in their online account. 3. User 1 sends user 2 $100. 4. User 1 has $400 in their account. 5. User 2 has $300 in their account.
Which of the following scenarios reflects the durability property?
-
1. A fairly large update is made to the products table.
2. The update is saved to the logs.
3. The update starts to then save to the disk.
4. The system fails midway through.
5. When the system starts back up, the committed transactions that haven't been written to disk are written. -
1. The product quantity starts at 200.
2. Transaction 1 runs to read the quantity of the product to be updated.
3. Transaction 2 runs in parallel to read the quantity of the product to be updated.
4. Transaction 1 updates the product quantity to reduce it by 100.
5. Transaction 2 updates the product quantity to reduce it by 5.
6. The product quantity ends at 195. -
1. Transaction 1 reads a product's cost which is set at $100.
2. Transaction 1 updates the product to set the price to $90.
3. Transaction 2 reads the same product's cost and sees $100.
4. Transaction 1 commits the cost.
5. Transaction 3 reads the same product's cost and sees $90. -
1. User 1 has $500 in their online account.
2. User 2 has $300 in their online account.
3. User 1 sends user 2 $100.
4. User 1 has $400 in their account.
5. User 2 has $300 in their account.
Step by step
Solved in 2 steps