Transaction and Concurrency
1. A _________ consists of a sequence of query and/or update statements.
A.  Transaction B.  Commit C.  Rollback D.  Flashback
2. Which of the following makes the transaction permanent in the database?
A.  View B.  Commit C.  Rollback D.  Flashback
3. In order to undo the work of transaction after last commit which one should be used?
A.  View B.  Commit C.  Rollback D.  Flashback
4. What does Rollback do?
A.  Undoes the transactions before commit B.  Clears all transactions C.  Redoes the transactions before commit D.  No action
5. In case of any shut down during transaction before commit which of the following statement is done automatically?
A.  View B.  Commit C.  Rollback D.  Flashback
6. In order to maintain the consistency during transactions, database provides
A.  Commit B.  Atomic C.  Flashback D.  Retain
7. Transaction processing is associated with everything below except
A.  Conforming an action or triggering a response B.  Producing detail summary or exception report C.  Recording a business activity D.  Maintaining a data
8. A transaction completes its execution is said to be
A.  Committed B.  Aborted C.  Rolled back D.  Failed
9. Which of the following is used to get back all the transactions back after rollback?
A.  Commit B.  Rollback C.  Flashback D.  Redo
10. ______ will undo all statements up to commit?
A.  Transaction B.  Flashback C.  Rollback D.  Abort