MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 10 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_COMMITS_AS_SOON_AS_ITS_COMMIT_LOG_RECORD_IS_WRITTEN_TO_STABLE_STORAGE_AT_THE_PRIMARY_AND_THE_BACKUP_SITE._THIS_IS?$ |
| A. | One Safe |
| B. | Two Safe |
| C. | Two-very Safe |
| D. | Very Safe |
| Answer» D. Very Safe | |
| 2. |
If_only_the_primary_is_active,_the_transaction_is_allowed_to_commit_as_soon_as_its_commit_log_record_is_written_to_stable_storage_at_the_primary_site._This_is$ |
| A. | One Safe |
| B. | Two Safe |
| C. | Two-very Safe |
| D. | Very Safe |
| Answer» C. Two-very Safe | |
| 3. |
A transaction commits as soon as its commit log record is written to stable storage at the primary site. This i? |
| A. | One Safe |
| B. | Two Safe |
| C. | Two-very Safe |
| D. | Very Safe |
| Answer» B. Two Safe | |
| 4. |
A _______________ configuration can make takeover by the backup site almost instantaneous. |
| A. | Hot-spare |
| B. | Remote |
| C. | Direct |
| D. | Spare |
| Answer» E. | |
| 5. |
The time to process the remote backup can be reduced by |
| A. | Flags |
| B. | Breakpoints |
| C. | Redo points |
| D. | Checkpoints |
| Answer» E. | |
| 6. |
The simplest way of transferring control is for the old primary to receive __________ from the old backup site. |
| A. | Undo logs |
| B. | Redo Logs |
| C. | Primary Logs |
| D. | All of the mentioned |
| Answer» D. All of the mentioned | |
| 7. |
When the __________ the backup site takes over processing and becomes the primary. |
| A. | Secondary fails |
| B. | Backup recovers |
| C. | Primary fails |
| D. | None of the mentioned |
| Answer» D. None of the mentioned | |
| 8. |
The backup is taken by |
| A. | Erasing all previous records |
| B. | Entering the new records |
| C. | Sending all log records from primary site to the remote backup site |
| D. | Sending selected records from primary site to the remote backup site |
| Answer» D. Sending selected records from primary site to the remote backup site | |
| 9. |
Remote backup system must be _________ with the primary site. |
| A. | Synchronised |
| B. | Separated |
| C. | Connected |
| D. | Detached but related |
| Answer» B. Separated | |
| 10. |
The remote backup site is sometimes also called the |
| A. | Primary Site |
| B. | Secondary Site |
| C. | Tertiary Site |
| D. | None of the mentioned |
| Answer» C. Tertiary Site | |