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
23. Locking and timestamp ordering are optimistic techniques, as they are designed based on the assumption that conflict is rare.
- TRUE
- FALSE
25. In the two-phase locking, every transaction is divided into (a0 growing phase and (b) shrinking phase.
- TRUE
- FALSE
26. A dirty read problem occurs when one transaction updates a database item and then the transaction fails for some reason.
- TRUE
- FALSE
27. The size of the locked item determines the granularity of the lock.
- TRUE
- FALSE
28. There is no deadlock in the timestamp method of concurrency control.
- TRUE
- FALSE
29. A transaction that changes the contents of the database must alter the database from one consistent state to another
- TRUE
- FALSE
30. A transaction is said to be in committed state if it has partially committed, and it can be ensured that it will never be aborted.
- TRUE
- FALSE