MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 8 Mcqs, each offering curated multiple-choice questions to sharpen your Database knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
A_TRANSACTION_COMPLETES_ITS_EXECUTION_IS_SAID_TO_BE?$ |
| A. | Committed |
| B. | Aborted |
| C. | Rolled back |
| D. | Failed |
| Answer» D. Failed | |
| 2. |
Which_of_the_following_is_used_to_get_back_all_the_transactions_back_after_rollback?$ |
| A. | Commit |
| B. | Rollback |
| C. | Flashback |
| D. | Redo |
| Answer» D. Redo | |
| 3. |
Transaction processing is associated with everything below excep? |
| A. | Conforming an action or triggering a response |
| B. | Producing detail summary or exception report |
| C. | Recording a business activity |
| D. | Maintaining a data |
| Answer» B. Producing detail summary or exception report | |
| 4. |
In order to maintain the consistency during transactions, database provides |
| A. | Commit |
| B. | Atomic |
| C. | Flashback |
| D. | Retain |
| Answer» B. Atomic | |
| 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 |
| Answer» C. Rollback | |
| 6. |
In order to undo the work of transaction after last commit which one should be used? |
| A. | View |
| B. | Commit |
| C. | Rollback |
| D. | Flashback |
| Answer» D. Flashback | |
| 7. |
Which of the following makes the transaction permanent in the database? |
| A. | View |
| B. | Commit |
| C. | Rollback |
| D. | Flashback |
| Answer» C. Rollback | |
| 8. |
A _________ consists of a sequence of query and/or update statements. |
| A. | Transaction |
| B. | Commit |
| C. | Rollback |
| D. | Flashback |
| Answer» B. Commit | |