Oracle 1Z1-066 Value Pack (Frequently Bought Together)

A customer asks you to propose the most appropriate solution for this set of requirements:
1. We need a disaster recovery solution that enables us to fail over from our production database with zero data loss.
2. We want to generate reports from the proposed standby database at the same time that it is used for other purposes.
3. Developers may need to test occasionally on a copy of the live database.
You have already confirmed that there are no unsupported data types on the primary database.
Which two solutions would you recommend? (Choose two.)

• A. a snapshot standby database with synchronous redo transport
• B. a logical standby database
• C. a physical standby database with real-time query enabled
• D. a read mostly implementation of a physical standby database
• E. a remote physical standby database with RedoRoutes via a far sync instance

Which three statements are true about Data Guard configurations? (Choose three.)

• A. All databases in one Data Guard environment must have the same database name.
• B. The Oracle recommendation for the number of standby redo log groups per thread is one more than the number of online redo log groups per thread.
• C. For Standard Edition, LOG_ARCHIVE_DUPLEX_DEST is used to configure redo transport, from the primary to the standby database.
• D. When using the Data Guard Broker, an spfile is not required.
• E. VALID_FOR is a LOG_ARCHIVE_DEST_N attribute that enables DB role change operations without having to modify LOG_ARCHIVE_DEST_n when performing switchovers or failovers.
• F. Up to 30 physical standby databases may exist within one configuration.

Which two Data Guard features require the use of flashback database by the broker? (Choose two.)

• A. Snapshot Standby databases
• B. Far Sync Instances
• C. Read-Mostly physical standby implementations
• D. Fast-Start Failover
• E. Real Time Query

Which two are prerequisites for configuring Transaction Guard in a Data Guard environment? (Choose two.)

• A. Create a database service with COMMIT_OUTCOME set to TRUE and ensure that the service is statically registered with the default listener on the primary host.
• B. Set INSTANCE_NAME identically on all the Data Guard Configuration databases and modify the local service name on the client to include a CONNECTION_LIST containing all the standby hosts.
• C. Create a database service with COMMIT_OUTCOME set to TRUE, and ensure clients use that service to connect to the database instance.
• D. Ensure that connection descriptors for database clients use the failover clause with the COMMIT_OUTCOME parameter set to TRUE.
• E. Grant execute permission on the DBMS_APP_CONT package to relevant database schema owners.

Which three are true concerning Automatic Block Media Recovery in a Data Guard environment when running an application as an ordinary Oracle user? (Choose three.)

• A. If a physically corrupt block is discovered on the primary database, then a valid block image from a physical standby database is retrieved.
• B. If a physically corrupt block is discovered on a logical standby database, then a valid block image from the primary database is retrieved.
• C. If a physically corrupt block is discovered on a primary database, then a valid block image from the logically standby database is retrieved.
• D. If a physically corrupt block is discovered on a physical standby database, then a valid block image from the primary database is retrieved.
• E. Real Time Query must be enabled on the primary database.
• F. Real Time Query must be enabled on the physical standby database.