Which two statements are true for Data Guard environments with multi-tenant databases?
A. DB_UNIQUE_NAME must be specified differently for each pluggable database within a multi-tenant standby database.
B. Each pluggable database within a multi-tenant physical standby database has a minimum of one associated Oracle Net service name.
C. Each pluggable database within a multi-tenant physical standby has one MRP background process running during redo apply.
D. A pluggable database within a multi-tenant standby database can have a different open mode than the container database
E. A pluggable database within a multi-tenant standby database can have a different database role than the container database.
Which four statements are true regarding SQL Apply filters for a logical standby database?
A. They can be used to skip execution of DML triggers on a table while allowing the DML to execute.
B. They can be used to skip ALTER SYSTEM and ALTER DATABASE commands
C. They can be used to stop SQL apply if it encounters an error.
D. They can be used to skip all SQL statements executed on a specific pluggable database (PDB) within a standby multitenant container database (CDB).
E. They can only be used to skip DML statements on a table
F. They can be used to skip ALTER TABLE commands on a specific tables
G. They can be used to skip CREATE TABLE commands
A query on the view DBA_LOGSTBY_UNSUPPORTED on your primary database returns no rows
As a result of this, you decide that an upgrade may use logical standby databases.
Which two are true about upgrading Data Guard environments consisting of one logical standby database running on a separate host from the primary?
A. The upgrade always requires downtown until the upgrade of the logical standby is completed
B. Using manual upgrade, catctl.pl can be executed in some cases on the primary and standby database simultaneously.
C. The upgrade always required downtime until the upgrade of the primary is completed
D. Using manual upgrade, catupgr.sql needs to run on the primary database only.
E. SQL Apply on the local standby database must be stopped while the primary database is upgraded.
F. Fast-Start Failover can be used to protect the primary database during the upgrade.
Which two Data Guard features require the use of flashback database by the broker?
A. Read-Mostly physical standby implementations
B. Far Sync Instances
C. Fast-Start Failover
D. Real Time Query
E. Snapshot Standby databases
A query on the view DBA_LOGSTDBY_UNSUPPORTED on your primary database returns several rows.
As a result of this, you decide that an upgrade may not use logical standby databases
Which three are true about upgrading Data Guard environments consisting of one physical standby database running on a separate host from the primary?
A. The upgrade requires downtime until the upgrade of the standby is completed.
B. The broker must be disabled during the upgrade
C. With manual upgrade, catupgrd.sql can be executed on the primary and standby databases simultaneously.
D. The upgrade requires downtime until the upgrade of the primary is completed.
E. The new release of the Oracle Software must be installed on both the primary and standby database hosts
F. Redo Apply on the standby database must be stopped while the primary database is upgraded.
G. Fast-Start Failover can be used to protect the primary database during the upgrade.
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.
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.
Your Data Guard environment has two remote physical standby databases Client applications use the local naming method to connect to the primary database instance. You want applications to automatically connect to the new primary database instance in case of a
switchover or a failover Which will fulfill this requirement?
A. Create a database service on each standby database that is started automatically by a trigger, when the database rote is PRIMARY, modify the connection description used by client applications to include all the standby hosts and connect to the database instance using that service name.
B. Create a database service on the primary database that is started automatically by a trigger, when the database role is PRIMARY, modify the connection descriptors used by client applications to include all the standby hosts and connect to the database instance using that service name.
C. Set the INSTANCE_NAME parameter identically on all databases; modify the connection descriptor on client applications to include all the standby hosts and connect to the database instance using that service name.
D. Set the DB_NAME and DB_UNIQUE_NAME identical on all databases, modify the connection descriptors on client applications to include all the standby hosts and connect to the database using that service name.
Which four requirements can be met by deploying a logical standby database?
A. Support for workloads requiring additional indexes.
B. it can be used to create additional schemas.
C. it can be used to create additional tables.
D. It must have the same physical structure as the primary database.
E. it must provide a disaster-recovery solution that protects all data with capability of performing switchovers and failovers.
F. Support for workloads requiring additional materialized views.
G. it can be used for Real Application Testing without affecting the disaster recovery capabilities.
Which two are true about management of a far sync instance when using the Data Guard Broker?
A. A far sync instance is in a disabled state in the broker configuration immediately after adding it
B. A far sync instance that has its RedoRoutes property set may not be disabled in the broker configuration.
C. Broker management of a far sync instance may only be disabled with the disable configuration DGMGRL command.
D. A far sync instance need not exist before adding it to the broker configuration but may not be enabled until created
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.