Home / CSE MCQs / DBMS MCQs :: Transactions - DBMS

CSE MCQs :: DBMS MCQs

  1. A _________ consists of a sequence of query and/or update statements.
  2. A.
    Transaction
    B.
    Commit
    C.
    Rollback
    D.
    Flashback

  3. Which of the following makes the transaction permanent in the database ?
  4. A.
    View
    B.
    Commit
    C.
    Rollback
    D.
    Flashback

  5. In order to undo the work of transaction after last commit which one should be used ?
  6. A.
    View
    B.
    Commit
    C.
    Rollback
    D.
    Flashback

  7. Consider the following action:
    Transaction¦..
    Commit;
    Rollback;
    What does Rollback do?
  8. A.
    Undoes the transactions before commit
    B.
    Clears all transactions
    C.
    Redoes the transactions before commit
    D.
    No action

  9. In case of any shut down during transaction before commit which of the following statement is done automatically ?
  10. A.
    View
    B.
    Commit
    C.
    Rollback
    D.
    Flashback

  11. In order to maintain the consistency during transactions database provides
  12. A.
    Commit
    B.
    Atomic
    C.
    Flashback
    D.
    Retain

  13. Transaction processing is associated with everything below except
  14. A.
    Conforming a action or triggering a response
    B.
    Producing detail summary or exception report
    C.
    Recording a business activity
    D.
    Maintaining a data

  15. A transaction completes its execution is said to be
  16. A.
    Committed
    B.
    Aborted
    C.
    Rolled back
    D.
    Failed

  17. Which of the following is used to get back all the transactions back after rollback ?
  18. A.
    Commit
    B.
    Rollback
    C.
    Flashback
    D.
    Redo

  19. ______ will undo all statements up to commit?
  20. A.
    Transaction
    B.
    Flashback
    C.
    Rollback
    D.
    Abort