Transactions(Engineering > Computer Science And Engineering > Dbms Questions And Answers ) Questions and Answers
Question 1. A _________ consists of a sequence of query and/or update statements.
Transaction
Commit
Rollback
Flashback
Explanation:-
Answer: Option A. -> Transaction
TransactionTransaction is a set of operation until commit.
Question 2. In order to undo the work of transaction after last commit which one should be used ?
View
Commit
Rollback
Flashback
Explanation:-
Answer: Option C. -> Rollback
RollbackRollback work causes the current transaction to be rolled back; that is, it undoes all the updates performed by the SQL statements in the transaction.
Question 3. Which of the following makes the transaction permanent in the database ?
View
Commit
Rollback
Flashback
Explanation:-
Answer: Option B. -> Commit
CommitCommit work commits the current transaction.
Question 4. Consider the following action:Transaction¦..Commit;Rollback;What does Rollback do?
Undoes the transactions before commit
Clears all transactions
Redoes the transactions before commit
No action
Explanation:-
Answer: Option D. -> No action
No actionOnce a transaction has executed commit work, its effects can no longer be undone by rollback work.
Question 5. In case of any shut down during transaction before commit which of the following statement is done automatically ?
View
Commit
Rollback
Flashback
Explanation:-
Answer: Option C. -> Rollback
RollbackOnce a transaction has executed commit work, its effects can no longer be undone by rollback work.
Question 6. In order to maintain the consistency during transactions database provides
Commit
Atomic
Flashback
Retain
Explanation:-
Answer: Option B. -> Atomic
AtomicBy atomic , either all the effects of the transaction are reflected in the database, or none are (after rollback).
Question 7. ______ will undo all statements up to commit?
Transaction
Flashback
Rollback
Abort
Explanation:-
Answer: Option C. -> Rollback
RollbackFlashback will undo all the statements and Abort will terminate the operation.
Question 8. Which of the following is used to get back all the transactions back after rollback ?
Commit
Rollback
Flashback
Redo
Explanation:-
Answer: Option C. -> Flashback
Flashback
Question 9. A transaction completes its execution is said to be
Committed
Aborted
Rolled back
Failed
Explanation:-
Answer: Option A. -> Committed
CommittedA complete transaction always commits.
Question 10. Transaction processing is associated with everything below except
Conforming a action or triggering a response
Producing detail summary or exception report
Recording a business activity
Maintaining a data
Explanation:-
Answer: Option A. -> Conforming a action or triggering a response