READ Free Dumps For Oracle- 1z0-023
| Question ID 8890 | Why would a DBA create multiple online redo log members in a single group?
|
| Option A | To distribute I/O.
|
| Option B | To back up the database.
|
| Option C | To protect against a single point of failure.
|
| Option D | To write the second redo log after the first redo log is full.
|
| Correct Answer | C |
Explanation Explanation Explanation/Reference: Explanation: Answer C is correct. To protect against a single point failure (disk crash, for example) a DBA create multiple online redo log members for each log group. This process is called multiplexing of redo log files. Incorrect Answers: A: Multiplexing redo log files will not help to distribute I/O because Oracle will write into all members of current group. B: Multiplexing of redo log files does not work with backup of the database. D: Multiplexing is used for hardware failure. Second redo log file will be written after first redo log is full in any case, disregarding of multiplexing. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 330-332 Chapter 10: Managing Database Use
| Question ID 8891 | In response to the ARCHIVE LOG LIST command, Oracle displays: Database log mode No Archive ModeAutomatic archival EnabledArchive destination C:\ora\backup\archivelogsOldest online log sequence 1059 Current log sequence 1061 The DBA has not issued by any ALTER SYSTEM commands after starting the database. What is the value of the parameter LOG_ARCHIVE_START?
|
| Option A | TRUE
|
| Option B | FALSE
|
| Option C | ENABLED
|
| Option D | NOARCHIVELOG
|
| Correct Answer | A |
Explanation Explanation/Reference: Explanation: Answer A is correct. LOG_ARCHIVE_START value will be TRUE, because automatic archival is enabled. Incorrect Answers: B: LOG_ARCHIVE_START=TRUE, not FALSE. C: Value for LOG_ARCHIVE_START can be TRUE or FALSE, not ENABLED. D: Value for LOG_ARCHIVE_START can be TRUE or FALSE, not NOARCHIVELOG. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 325-327 Chapter 7: Managing the Physical Database Structure