DBMS-Transaction Processing and Concurrency Control
DBMS-Transaction Processing and Concurrency Control
31. Level 3 transaction consistency adds consistent reads so that successive reads of a record will always give the same values
- TRUE
- FALSE
32. A lost update problem occurs when two transctions that access the same database items have their operations in a way that makes the value of some database item incorrect.
- TRUE
- FALSE
33. Serialisability describes the concurrent execution of serveral tranactions.
- TRUE
- FALSE
34. Unrepeadtable read occure when a transaction calculates some summary function over a set of data while other transactions are updating the data
- TRUE
- FALSE
35. It prevents access to a database record by a second transaction until the first transaction has completed all of its actions.
- TRUE
- FALSE
36. In a shrinking phase, a transaction releases all locks and cannot obtain any new lock.
- TRUE
- FALSE
38. Which of the following is the activity of coordinating the actions of process that operate in parallel and access shared data?
- Transaction management
- Recovery management
- Concurrency control
- None of these
39. Which of the following is the ability of a DBMS to manage the various transactions that occur within the system ?
- Transaction management
- Recovery management
- Concurrency control
- None o these
40. Which of the following tranaction property?
- Isolation
- Durability
- Atomicity
- All of these