DBMS-Transaction Processing and Concurrency Control
DBMS-Transaction Processing and Concurrency Control
11. Log is a record of all transactions and the corresponding changes to the database.
- TRUE
- FALSE
12. Level 2 transaction consistency isolates from the updates of other transactions.
- TRUE
- FALSE
13. Level 2 transaction consistency isolates from the updates of other transactions.
- TRUE
- FALSE
14. Level 1 transaction is the minimum consistency requirement that allows a transaction to be recovered in the event of system failure.
- TRUE
- FALSE
15. A committed transaction that has performed updates transforms the database into a new cosnsistent state.
- TRUE
- FALSE
16. The objective of concurrency control is to schedule or arrange the transactions in such a way was to avoid any interference.
- TRUE
- FALSE
17. The objective of concurrency control is to schedule or arrange the transactions in such a way as to avoid any interference.
- TRUE
- FALSE
18. Incorrect analysis problem is also known as dirty read or unrepeatable read.
- TRUE
- FALSE
19. A consistent database state is one in which all data integrity cosnstraints are satisfied.
- TRUE
- FALSE
20. the serial execution always leaves the database in a consistent state although different results could be produced depending on the order of execution.
- TRUE
- FALSE