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

    View Answer

    Workspace

    Discuss Discuss in Forum


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

    View Answer

    Workspace

    Discuss Discuss in Forum


  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

    View Answer

    Workspace

    Discuss Discuss in Forum


  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

    View Answer

    Workspace

    Discuss Discuss in Forum


  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

    View Answer

    Workspace

    Discuss Discuss in Forum


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

    View Answer

    Workspace

    Discuss Discuss in Forum


  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

    View Answer

    Workspace

    Discuss Discuss in Forum


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

    View Answer

    Workspace

    Discuss Discuss in Forum


  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

    View Answer

    Workspace

    Discuss Discuss in Forum


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

    View Answer

    Workspace

    Discuss Discuss in Forum