DBMS-Transaction Processing and Concurrency Control
DBMS-Transaction Processing and Concurrency Control
1. The transaction cosnsists of all the operations executed between the beginning and end of the transaction.
- TRUE
- FALSE
2. A transaction is a program unit, which can either be embedded withing an applicant program or can be specified interctively via a high-level query language such as SQL.
- TRUE
- FALSE
3. A transaction that is either committed or aborted is said to be terminated.
- TRUE
- FALSE
4. A transaction that is either committed or aborted is said to be terminated.
- TRUE
- FALSE
5. Atomic transaction is transactions in which either all actions associated with the transaction are executed to completion, or none are performed.
- TRUE
- FALSE
6. The effects of a successfully completed transaction are permanently recorded in the database and must not be lost because of a subsequent failure.
- TRUE
- FALSE
8. Level 1 transaction is the minimum consistency requirement that allows a transaction to be recovered in the event of system failure.
- TRUE
- FALSE
9. Level 1 transaction is the minimum consistency requirement that allows a transaction to be recovered in the event of system failure.
- TRUE
- FALSE
10. Level 1 transaction is the minimum consistency requirement that allows a transaction to be recovered in the event of system failure.
- TRUE
- FALSE