Home / CSE MCQs / DBMS MCQs :: Deadlocks - DBMS

CSE MCQs :: DBMS MCQs

  1. A system is in a ______ state if there exists a set of transactions such that every transaction in the set is waiting for another transaction in the set.
  2. A.
    Idle
    B.
    Waiting
    C.
    Deadlock
    D.
    Ready

  3. The deadlock state can be changed back to stable state by using _____________ statement.
  4. A.
    Commit
    B.
    Rollback
    C.
    Savepoint
    D.
    Deadlock

  5. What are the ways of dealing with deadlock ?
  6. A.
    Deadlock prevention
    B.
    Deadlock recovery
    C.
    Deadlock detection
    D.
    All of the mentioned

  7. When transaction Ti requests a data item currently held by Tj , Ti is allowed to wait only if it has a timestamp smaller than that of Tj (that is, Ti is older than Tj ). Otherwise, Ti is rolled back (dies). This is
  8. A.
    Wait-die
    B.
    Wait-wound
    C.
    Wound-wait
    D.
    Wait

  9. When transaction Ti requests a data item currently held by Tj , Ti is allowed to wait only if it has a timestamp larger than that of Tj (that is, Ti is younger than Tj ). Otherwise, Tj is rolled back (Tj is wounded by Ti ). This is
  10. A.
    Wait-die
    B.
    Wait-wound
    C.
    Wound-wait
    D.
    Wait

  11. The deadlock in a set of transaction can be determined by
  12. A.
    Read-only graph
    B.
    Wait graph
    C.
    Wait-for graph
    D.
    All of the mentioned

  13. A deadlock exists in the system if and only if the wait-for graph contains a ___________.
  14. A.
    Cycle
    B.
    Direction
    C.
    Bi-direction
    D.
    Rotation

  15. Selecting the victim to be rollbacked to the previous state is determined by the minimum cost. The factors determining cost of rollback is
  16. A.
    How long the transaction has computed, and how much longer the transaction will compute before it completes its designated task.
    B.
    How many data items the transaction has used.
    C.
    How many more data items the transaction needs for it to complete.
    D.
    How many transactions will be involved in the rollback.
    E.
    All of the mentioned

  17. __________ rollback requires the system to maintain additional information about the state of all the running transactions.
  18. A.
    Total
    B.
    Partial
    C.
    Time
    D.
    Commit

  19. Which of these is data type long literal?
  20. A.
    0x99fffL
    B.
    ABCDEFG
    C.
    0x99fffa
    D.
    99671246