MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 17 Mcqs, each offering curated multiple-choice questions to sharpen your Oracle (MCQ) questions and answers knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
What is a redo record called? |
| A. | Redo entry |
| B. | Redo thread |
| C. | Both A & B |
| D. | None of the above |
| Answer» B. Redo thread | |
| 2. |
What indicates whether there was a problem accessing the destination in an Archive Destination Status? |
| A. | Enabled/Disabled |
| B. | Active/Inactive |
| C. | Valid/Invalid |
| D. | All mentioned above |
| Answer» C. Valid/Invalid | |
| 3. |
Which shows if the database is in ARCHIVELOG or NOARCHIVELOG mode and if MANUAL (archiving mode) has been specified in a Dynamic performance view? |
| A. | V$ARCHIVED_LOG |
| B. | V$DATABASE |
| C. | V$ARCHIVE_DEST |
| D. | V$ARCHIEVE_PROCESSES |
| Answer» C. V$ARCHIVE_DEST | |
| 4. |
Which mode protects a database from instance failure but not from media failure? |
| A. | ARCHIVELOG MODE |
| B. | NOARCHIVELOG MODE |
| C. | Both A & B |
| D. | None of the above |
| Answer» C. Both A & B | |
| 5. |
What does the redo log for each database instance referred to as in the context of multiple database instances? |
| A. | Redo thread |
| B. | Redo entry |
| C. | Redo record |
| D. | All mentioned above |
| Answer» B. Redo entry | |
| 6. |
What is the minimum size permitted for a redo log file? |
| A. | 10 MB |
| B. | 6 MB |
| C. | 8 MB |
| D. | 4 MB |
| Answer» E. | |
| 7. |
Which parameter is used to specify a maximum of two locations,used to specify a primary archive destination? |
| A. | LOG_ARCHIVE_DEST |
| B. | LOG_ARCHIVE_DUPLEX_DEST |
| C. | LOG_ARCHIVE_FORMAT |
| D. | None of the above |
| Answer» B. LOG_ARCHIVE_DUPLEX_DEST | |
| 8. |
Which parameter is used in the CREATE DATABASE statement that determines the maximum number of groups of redo log files for each database? |
| A. | MAXLOGMEMBERS |
| B. | MAXLOGFILES |
| C. | DEFAULT |
| D. | Both A & B |
| Answer» C. DEFAULT | |
| 9. |
Which modes are used for transmitting archived logs to their destination inthe Specifying Mode of Log Transmission? |
| A. | Normal archiving transmission |
| B. | Standby transmission |
| C. | Both A & B |
| D. | None of the above |
| Answer» D. None of the above | |
| 10. |
A filled redo log file is available after the changes recorded in it have been written to the datafiles if archiving is ______. |
| A. | Enabled |
| B. | Disabled |
| C. | Both A & B |
| D. | None of the above |
| Answer» C. Both A & B | |
| 11. |
What does the status DEFER indicate in the LOG_ARCHIVE_DEST_STATE_n initialization parameter which lets you control the availability state of the specified destination (n)? |
| A. | Indicates that the database can use the destination |
| B. | Indicates that the location is temporarily disabled |
| C. | Indicates that the destination is an alternate |
| D. | All mentioned above |
| Answer» C. Indicates that the destination is an alternate | |
| 12. |
Which view identifies redo log groups and members and member status in the Redo Log Information? |
| A. | V$LOG |
| B. | V$LOGFILE |
| C. | V$LOG_HISTORY |
| D. | None of the above |
| Answer» C. V$LOG_HISTORY | |
| 13. |
What is the impact on performance if the ARCHIVE_LAG_TARGET initialization parameter is set to a very low value? |
| A. | Positive |
| B. | Negative |
| C. | None |
| D. | All mentioned above |
| Answer» C. None | |
| 14. |
What are the Archived redo logs used for? |
| A. | Recover a database |
| B. | Update a standby database |
| C. | Get information about the history of a database using the LogMiner utility |
| D. | All mentioned above |
| Answer» E. | |
| 15. |
What are the consequences of an ARCHIVE LOG LIST command stated below?SQL> ARCHIVE LOG LISTDatabase log mode Archive ModeAutomatic archival EnabledArchive destination D: oracle oradata IDDB2 archiveOldest online log sequence 11160Next log sequence to archive 11163Current log sequence 11163 |
| A. | The database is currently operating in NOARCHIVELOG mode |
| B. | Automatic archiving is disabled |
| C. | The current redo log file has a sequence number of 11160 |
| D. | None of the above |
| Answer» E. | |
| 16. |
Which transmission involves transmitting files to a local disk? |
| A. | Standby transmission |
| B. | Normal transmission |
| C. | Both A & B |
| D. | None of the above |
| Answer» C. Both A & B | |
| 17. |
What are the Redo log files that are no longer required for instance recovery called? |
| A. | Active Redo log files |
| B. | Inactive Redo log files |
| C. | Current |
| D. | None of the above |
| Answer» C. Current | |