Sail E0 Webinar

MCQs

Total Questions : 10
Question 1. A _________ consists of a sequence of query and/or update statements.
  1.    Transaction
  2.    Commit
  3.    Rollback
  4.    Flashback
 Discuss Question
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 ?
  1.    View
  2.    Commit
  3.    Rollback
  4.    Flashback
 Discuss Question
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 ?
  1.    View
  2.    Commit
  3.    Rollback
  4.    Flashback
 Discuss Question
Answer: Option B. -> Commit


CommitCommit work commits the current transaction.


Question 4. Consider the following action:Transaction¦..Commit;Rollback;What does Rollback do?
  1.    Undoes the transactions before commit
  2.    Clears all transactions
  3.    Redoes the transactions before commit
  4.    No action
 Discuss Question
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 ?
  1.    View
  2.    Commit
  3.    Rollback
  4.    Flashback
 Discuss Question
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
  1.    Commit
  2.    Atomic
  3.    Flashback
  4.    Retain
 Discuss Question
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?
  1.    Transaction
  2.    Flashback
  3.    Rollback
  4.    Abort
 Discuss Question
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 ?
  1.    Commit
  2.    Rollback
  3.    Flashback
  4.    Redo
 Discuss Question
Answer: Option C. -> Flashback


Flashback


Question 9. A transaction completes its execution is said to be
  1.    Committed
  2.    Aborted
  3.    Rolled back
  4.    Failed
 Discuss Question
Answer: Option A. -> Committed


CommittedA complete transaction always commits.


Question 10. Transaction processing is associated with everything below except
  1.    Conforming a action or triggering a response
  2.    Producing detail summary or exception report
  3.    Recording a business activity
  4.    Maintaining a data
 Discuss Question
Answer: Option A. -> Conforming a action or triggering a response


Conforming a action or triggering a response


Latest Videos

Latest Test Papers