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
41. Which of the following ensures the consistency of the transactions ?
- Application programmer
- concurrency control
- Recovery management
- Transaction management
42. Which of the following ensures the durability of a transaction ?
- Application programmer
- Concurrency control
- Recovery management
- Transaction management
43. In a shrinking phase, a transaction:
- release all locks
- cannot obtain any new lock
- both (a) and (b)
- none of these
44. Which of the following ensures the atomicity of a transaction ?
- Application programmer
- Concurrency control
- Recovery management
- Tranasction management.
45. Which of the following ensures the isolation of a transaction ?
- Application programmer
- Concurrency control
- Recovery management
- Transaction management
46. Which of the following is a transaction state ?
- Active
- Commit
- Aborted
- All of these
47. The concurrency control has he following problem :
- lost updates
- dirty read
- unrepeatable read
- all o these
48. Which of the following is not a transaction management SQL command ?
- COMMIT
- SELECT
- SAVEPOINT
- ROLLBACK
49. Which of the following is a statement after which you cannot issue a COMMIT command ?
- INSER
- SELECT
- UPDATE
- DELETE
50. Timestamps must have following properties namely.
- uniqueness
- monotonicity
- both (a) and (b)
- none of these