DBMS-Transaction Processing and Concurrency Control Questions and Answers
Transaction Processing and Concurrency Control are crucial aspects of DBMS ensuring data integrity in multi-user systems. This topic includes database programming questions and answers covering ACID properties, concurrency problems, and locking mechanisms. Perfect for TCS, Infosys, and Oracle placements, these questions provide practical insight into how databases manage simultaneous transactions safely. Master these DBMS Transaction Processing questions with answers to excel in database management interviews and academic tests.
DBMS-Transaction Processing and Concurrency Control
Showing 10 of
66 questions
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
37. A deadlock in a distributed system may be either local or global .
- 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