| 2/16 | 1 | 19 | ||||||||||||||||||||||
| 3 | 4 | |||||||||||||||||||||||
| 5 | ||||||||||||||||||||||||
| 6 | 17 | |||||||||||||||||||||||
| 7 | ||||||||||||||||||||||||
| 8 | ||||||||||||||||||||||||
| 9 | ||||||||||||||||||||||||
| 10 | ||||||||||||||||||||||||
| 18 | ||||||||||||||||||||||||
| 11 | ||||||||||||||||||||||||
| 15 | ||||||||||||||||||||||||
| 12 | ||||||||||||||||||||||||
| 13/14 | ||||||||||||||||||||||||
1. The property that ensures that committed transactions survive permanent system failures.
2. The process of restoring a database to a previous state using the information in the transaction log.
3. A specific action carried out on a database.
4. A mechanism used in the recovery process of a database to bring it to a consistent state after a crash.
5. The ability to recover a database to a specific moment in time using the transaction log.
6. A set of properties that guarantee that database transactions are processed reliably.
7. A file that records all the transactions and activities in a database system.
8. A sequential record of all the changes made to a database, stored in the transaction log.
9. A single, complete set of information within a table.
10. The process of determining the order in which transactions should be executed in a database system.
11. A concurrency control protocol where a transaction acquires all its required locks before starting execution and releases them all at the end. It enforces serializability.
12. A concurrency control technique in database systems where transactions are ordered based on their timestamp values.
13. The property that ensures transactions are executed in a way that they are unaware of each other.
14. A property that determines how concurrent transactions interact with each other and the level of data visibility.
15. A file that contains a systematic record of events, actions, or observations.
16. A process that reapplies the changes recorded in the transaction log during database recovery.
17. Techniques and mechanisms used to manage the simultaneous execution of transactions without interference or inconsistency.
18. A point within a transaction where you can roll back a part of the transaction instead of the entire transaction.
19. A mechanism used in the recovery process of a database to revert the effects of incomplete or aborted transactions.