| 1/14 | 16 | |||||||||||||||||||||||
| 2 | ||||||||||||||||||||||||
| 3 | ||||||||||||||||||||||||
| 4 | ||||||||||||||||||||||||
| 5 | 18 | |||||||||||||||||||||||
| 6 | ||||||||||||||||||||||||
| 7 | 15 | 19 | ||||||||||||||||||||||
| 8 | 17 | |||||||||||||||||||||||
| 9 | ||||||||||||||||||||||||
| 10 | ||||||||||||||||||||||||
| 11 | ||||||||||||||||||||||||
| 12 | ||||||||||||||||||||||||
| 13 | ||||||||||||||||||||||||
1. The process of determining the order in which transactions should be executed in a database system.
2. The process of performing multiple database operations as a single unit of work, ensuring consistency and integrity of data.
3. The ability to recover a database to a specific moment in time using the transaction log.
4. A mechanism used in the recovery process of a database to bring it to a consistent state after a crash.
5. A sequential record of all the changes made to a database, stored in the transaction log.
6. The property that allows multiple transactions to execute concurrently without interfering with each other.
7. The process of recording events, activities, and information to a log file or transaction log.
8. 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.
9. A unit of work performed on a database that follows the ACID approach.
10. The property of a transaction to be an indivisible operation, either all or none of its changes are applied.
11. A situation where two or more transactions are unable to proceed because each is waiting for the other to release a resource.
12. A concurrency control technique in database systems where transactions are ordered based on their timestamp values.
13. A mechanism used in the recovery process of a database to revert the effects of incomplete or aborted transactions.
14. A file that records all the transactions and activities in a database system.
15. A property that determines how concurrent transactions interact with each other and the level of data visibility.
16. A specific action carried out on a database.
17. A file that contains a systematic record of events, actions, or observations.
18. The property that ensures that committed transactions survive permanent system failures.
19. The process of undoing all changes made within a transaction and returning the database to its previous state.