DBMS-Transaction Processing and Concurrency Control
DBMS-Transaction Processing and Concurrency Control
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
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