B not only local directory can be used for the

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: al directory can be used for the LOG_ARCHIVE_DEST_n parameter. C: Not only a Net8 alias for a remote database can be used for the LOG_ARCHIVE_DEST_n parameter. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 577-585 Chapter 12: Overview of Backup and Recovery QUESTION 27: How can a DBA disable one of the current archive destinations? A. Issue the command ALTER SESSION SET LOG_ARCHIVE_DEST=DEFER. B. Shut down the database and delete the archive destination dictionary at the operating system level. C. Specify the initialization parameter LOG_ARCHIVE_DEST_STATE_n=DEFER. D. It is not possible to disable archive destinations? Answer: C Explanation: A DBA can use the initialization parameter LOG_ARCHIVE_DEST_STATE_n set to value DEFER to disable one of the current archive destinations. The SQL query below Actualtests.com - The Power of Knowing 1Z0-025 shows current state of archive destinations. SQL> select name || ' ' || value from v$parameter where 2UPPER (name) like 'LOG_ARCHIVE_DEST_STATE%'; NAME||''||VALUE -----------log_archive_dest_state_1 enable log_archive_dest_state_2 enable log_archive_dest_state_3 enable log_archive_dest_state_4 enable log_archive_dest_state_5 enable log_archive_dest_state_6 enable log_archive_dest_state_7 enable log_archive_dest_state_8 enable log_archive_dest_state_9 enable log_archive_dest_state_10 enable Incorrect Answers: A: ALTER SESSION SET ARCHIVE_LOG_DEST=DEFER command will not disable one of the current archive destinations...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online