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. |
WHICH_OF_THE_FOLLOWING_IS_NOT_A_STATE_IN_TRANSACTION??$ |
| A. | Active |
| B. | Terminated |
| C. | Aborted |
| D. | Partially committed |
| Answer» C. Aborted | |
| 2. |
DBMS periodically suspends all processing and synchronizes its files and journals through the use o? |
| A. | Checkpoint facility |
| B. | Backup facility |
| C. | Recovery manager |
| D. | Database change log |
| Answer» B. Backup facility | |
| 3. |
Which of the following is an atomic sequence of database actions? |
| A. | Transaction |
| B. | Concurrency |
| C. | Relations |
| D. | All of the mentioned |
| Answer» B. Concurrency | |
| 4. |
The name of the transaction file shall be provided by the operator and the file that contains the edited transactions ready for execution shall be called |
| A. | Batch. Exe |
| B. | Trans. Exe |
| C. | Opt. Exe |
| D. | Edit.Exe |
| Answer» D. Edit.Exe | |
| 5. |
When the transaction finishes the final statement the transaction enters into |
| A. | Active state |
| B. | Committed state |
| C. | Partially committed state |
| D. | Abort state |
| Answer» D. Abort state | |
| 6. |
Each modification done in database transaction are first recorded into the |
| A. | Harddrive |
| B. | Log |
| C. | Disk |
| D. | Datamart |
| Answer» C. Disk | |
| 7. |
If an transaction is performed in a database and committed, the changes are taken to the previous state of transaction by |
| A. | Flashback |
| B. | Rollback |
| C. | Both Flashback and Rollback |
| D. | Cannot be done |
| Answer» E. | |
| 8. |
A transaction may not always complete its execution successfully. Such a transaction is termed |
| A. | Aborted |
| B. | Terminated |
| C. | Closed |
| D. | All of the mentioned |
| Answer» B. Terminated | |