DBMS-Transaction Processing and Concurrency Control

DBMS-Transaction Processing and Concurrency Control
21. Cascading rollbacks are not desirable.
  • TRUE
  • FALSE
Show Answer
22. Cascading rollbacks are not desirable.
  • TRUE
  • FALSE
Show Answer
23. Locking and timestamp ordering are optimistic techniques, as they are designed based on the assumption that conflict is rare.
  • TRUE
  • FALSE
Show Answer
24. Two types of locks are Read and Write locks.
  • TRUE
  • FALSE
Show Answer
25. In the two-phase locking, every transaction is divided into (a0 growing phase and (b) shrinking phase.
  • TRUE
  • FALSE
Show Answer
26. A dirty read problem occurs when one transaction updates a database item and then the transaction fails for some reason.
  • TRUE
  • FALSE
Show Answer
27. The size of the locked item determines the granularity of the lock.
  • TRUE
  • FALSE
Show Answer
28. There is no deadlock in the timestamp method of concurrency control.
  • TRUE
  • FALSE
Show Answer
29. A transaction that changes the contents of the database must alter the database from one consistent state to another
  • TRUE
  • FALSE
Show Answer
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
Show Answer
Database
Questions and Answers for Competitive Exams Various Entrance Test