Protected or unprotected to control the degree of

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: perations are to be performed synchronously or asynchronously D. PROTECTED or UNPROTECTED to control the degree of divergence and data loss at the standby database Answer: A, B, C Explanation: The LOG_ARCHIVE_DEST_n initialization parameter control the data availability mode of a Data Guard standby database with three attributes: SYNC or ASYNC for the network transmission mode, LGWR or ARCH to identify the primary database process responsible for sending redo information to the standby and AFFIRM or NOAFFIRM to control whether log archiving disk write operations are to be performed synchronously or asynchronously. Incorrect Answers D: There is no PROTECTED or UNPROTECTED attribute for the LOG_ARCHIVE_DEST_n initialization parameter. OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 51-74 Chapter 2: Availability Enhancements Oracle 9i New Features, Robert Freeman, p. 86-99 Chapter 3: New Oracle9i Availability and Recoverability Features Actualtests.com - The Power of Knowing 1Z0-030 QUESTION 44: Which statement correctly describes the function of the Oracle9i Cache Fusion feature? A. It provides each session with its own view of the database at a different point in the past. B. It enables you to execute scalable applications on a clustered database without having to partition the users or the database tables. C. It lets you dynamically reassign memory in your database buffer cache to different block buffer sizes. D. It allows you to add new sites to multimaster replication environment without quiescing the master definition site. Answer: B Explanation: The Oracle9i Cache Fusion allows you to execute scalable applications on a clustered database without having to partition the users or the database tables. Incorrect Answers A: It does not provide each session with its own view of the database at a different point in the past. C: The Oracle9i Cache Fusion feature does not dynamically reassign memory in your database buffer cache to different block buffer sizes. D: It does not provide you ability to add new sites to multimaster replication environment without quiescing the master definition site. OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 223-230 Chapter 4: Performance and Scalability Enhancements Oracle 9i New Features, Robert Freeman, p. 193-206 Chapter 7: Oracle9i Real Application Clusters QUESTION 45: What is true if you want to switch undo tablespaces from the current one, called UNDO1, to a new one called UNDO2? A. It is NOT possible to switch unless no active transaction exists in UNDO1. B. It is possible to switch to UNDO2, but current active transactions will abort. C. It is possible to switch to UNDO2; current active transactions will be automatically migrated to UNDO2. D. It is possible to switch to UNDO2; only current active transactions will continue to execute inside UNDO1 Answer: D Actualtests.com - The Power of Knowing 1Z0-030 Explanation: You can switch undo tablespaces from the current one, called UNDO1, to a new one called UNDO2. Only current active transactions will continue to execute inside UNDO1, all n...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online