Which three statements are true about Data Guard configurations?
A. All databases in one Data Guard environment must have the same database name.
B. 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.
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. Up to 30 physical standby databases may exist within one configuration.
F. 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
Which three are true about using RMAN in a Data Guard environment?
A. A recovery catalog is required when RMAN is used to take backups from a logical standby database in a Data Guard configuration if you plan to recover the primary using those backups.
B. Backups of archived redo logs taken on a physical standby are interchangeable with a primary.
C. A recovery catalog is required when RMAN is used to take backups from a physical standby database if you plan to recover the primary using those backups
D. Backups of control files taken on a physical standby are not interchangeable with a primary.
E. Backups of data files taken on a physical standby are interchangeable with a primary.
Which two are prerequisites for enabling Automatic Block Media Recovery in a Data Guard environment consisting of a primary database, one physical standby database and one logical standby database?
A. FLASHBACK DATABASE must be enabled on the physical standby database.
B. There must be connectivity between the primary and the physical standby database.
C. FLASHBACK DATABASE must be enabled on the primary database.
D. The physical standby database must have Real-Time Apply enabled.
E. The logical standby database must have Real-Time Query enabled
You edit the DGConnectldentifier database property using the edit database set property DGMGRL command Which two are effects of this change?
A. The fal_client database initialization parameter on all standby databases is updated with the new value.
B. The service attribute of the log_archive_dest_n initialization parameter for any database referring to the specified database is updated with the new value.
C. The fal_client database initialization parameter for the specified database is updated with the new value
D. The broker configuration must be disabled and then enabled to use the new connection property.
E. The service attribute of the log_archive_dest_n initialization parameter referring to all standby databases is updated with the new value
Your Data Guard environment consists of these components and settings:
1.
A primary database
2.
Two remote physical standby databases
3.
The redo transport mode is set to SYNC.
4.
Real-time query is enabled for both standby databases.
5.
The DB_BLOCK_CHECKING parameter is set to TRUE on both standby databases.
You notice an increase in redo apply lag time on both standby databases.
Which two would you recommend to reduce the redo apply lag on the standby databases?
A. Increase the size of the buffer cache on the physical standby database instances.
B. Increase the number of standby redo log files on the standby databases.
C. Decrease the redo log file size on the primary database.
D. Lower DB_BLOCK_CHECKING to MEDIUM or LOW on the standby databases.
E. Increase the size of standby redo log files on the standby databases.
You created a physical standby database PRODSBY1 from the primary database PROD using SQL and RMAN Which two are prerequisites for creating a Data Guard Broker configuration to manage these databases?
A. The standby database must have supplemental logging enabled.
B. The primary database must have FORCE LOGGING enabled
C. The DG_BROKER_START parameter must be set to TRUE for both database instances.
D. The primary database must have supplemental logging enabled.
E. A local net service name to enable connectivity to the PRODSBY1 database instance must be defined on the primary database host.
Which three are always benefits of using a logical standby database?
A. it can be used for database rolling release upgrades
B. it can be used to replicate a single pluggable database (PDB) in a multitenant container database.
C. It can be used as an updatable database for Real Application testing and then converted back to a standby database without affecting the updates.
D. It can be used for reporting workloads requiring additional indexes or materialized views or both.
E. It provides a disaster-recovery solution with switchover and failover options that can recover any data updated on the primary database.
F. it can be used for testing patches without affecting the primary database.
Which two Data Guard monitoring activities may be performed using Enterprise Manager Cloud Control?
A. monitoring the redo apply rate on a physical standby
B. monitoring the redo apply rate on a logical standby
C. monitoring the undo generation rate on a logical standby
D. monitoring the redo apply rate on a snapshot standby
E. monitoring the transport lag
F. monitoring the undo generation rate on the primary
Your expertise is requested for these customer requirements:
1. The Data Guard environment must be in maximum protection mode. 2 Reports must be offloaded to a physical standby database.
3.
There must be no lag between the primary and standby databases that affect the reports produced.
4.
The primary database must be resilient in case of a single network failure.
Which solution is correct for these requirements?
A. two standby databases, at least one of them a physical standby with Real-Time Query enabled and the STANDBY_MAX_DELAY parameter set to zero, receiving redo from the primary with asynchronous transport
B. two standby databases, at least one of them a physical standby with Real-Time Query enabled and the STANDBY_MAX_DATA_DELAY parameter set to zero, receiving redo from the primary with synchronous transport
C. one physical standby database with Real-Time Query enabled, receiving redo from two Far Sync instances that are connected the primary
D. one physical standby database with Real-Time Query enabled and the STANDBY_MAX_DATA_DELAY parameter set to zero, receiving redo from the primary with synchronous transport
E. two physical standby databases with Real-Time Query enabled, receiving redo from the primary with the LOG_ARCHIVE_DEST_n attnbutes SYNC NOAFFIRM to minimize the performance impact on the primary.
You administer a Data Guard environment consisting of a primary and three physical standby databases.
One physical standby database is used for disaster recovery, one is used for reporting, and one is used as a replica for testing. The standby database used for testing is occasionally converted into a snapshot standby database and
then converted back to a physical standby.
The physical standby database is the only standby that is a mandatory destination
The broker configuration operates in MAXIMUM PERFORMANCE mode.
Which ARCHIVELOG DELETION POLICY should be set. so that archive logs generated on the primary
database are not deleted before they are consumed appropriately on each of the standby databases, but which allows them to be deleted form the primary as soon as it is safe to do so?
A. CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY
B. CONFIGURE ACHIVELOG DELETION POLICY TO APPLIED ON STANDBY;
C. CONFIGURE ACHIVELOG DELETION POLICY TO SHIPPED TO ALL STANDBY;
D. CONFIGURE ACHIVELOG DELETION POUCY TO SHIPPED TO STANDBY,
E. CONFIGURE ACHIVELOG DELETION POLICY TO NONE;
Nowadays, the certification exams become more and more important and required by more and more enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare for the exam in a short time with less efforts? How to get a ideal result and how to find the most reliable resources? Here on Vcedump.com, you will find all the answers. Vcedump.com provide not only Oracle exam questions, answers and explanations but also complete assistance on your exam preparation and certification application. If you are confused on your 1Z0-066 exam preparations and Oracle certification application, do not hesitate to visit our Vcedump.com to find your solutions here.