DBMS-Transaction Processing and Concurrency Control
DBMS-Transaction Processing and Concurrency Control
51. Which of the following is validation-based concurrency control?
- validation
- write
- read
- all of these
52. The READ and WRITE operations of database within the same transaction must have
- same timestamp
- different timestamp
- no timestamp
- none of these
53. Locking can take place at the following levels:
- Page level.
- Database level
- Terminated
- Aborted
54. Locking can take place at the following levels:
- Page level
- Database level
- Row level
- all of these
55. In binary locking, there are
- one state of locking
- two states of locking
- there states of locking
- none of these
56. The way to undo the effects of a committed transaction is ?
- Recovery
- Compensating transaction
- Roll back
- None of these
57. Which of the following is the size of thedata item chosen as theunit of protection by a concurrency control program ?
- Blocking factor
- Granularity
- Lock
- None of these
58. A transaction can include is a problem resulting from concurrent execution of transaction ?
- Read_item(X)
- Wrte_item(X)
- both (a) & (b)
- none of these
59. Which of the following is a problem resulting from concurrent execution of transaction ?
- Incorrect analysis
- Multiple update
- Ucommitted dependency
- all of these
60. Which of the following is not a deadlock handling strategy ?
- Timeout
- Deadlock annihilation
- Deadlock prevention
- Deadlock detection