1Z0-066 Online Practice Questions and Answers

You have a Data Guard Broker configuration called Somewhere' as shown: Which two are true about the output of this DGMGRL command?

A. A far sync instance cannot have inconsistent properties because it has no database.

B. It shows all properties whose broker configuration values for database Nearby are inconsistent with the broker configuration values for database Farout.

C. It shows all properties whose broker configuration values for database Nearby are inconsistent with the values in the corresponding server parameter file or the runtime values for database instance Nearby.

D. Any inconsistency reported is on an instance-specific basis.

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 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 the creation of a Data Guard Broker configuration?

A. in a broker configuration, the primary database name must match the DB_UNIQUE_NAME value in the database initialization parameter file.

B. A primary database profile may be added to the configuration prior to creating the primary database.

C. A standby database profile may be added to the configuration prior to creating that standby database.

D. A newly created broker configuration requires at least one standby database profile to be specified at the time the configuration is created.

E. A newly created broker configuration is in the disabled state

Which three factors can influence the rate of redo apply on a physical standby database?

A. the network latency between the primary and standby databases

B. the number of archiver processes on the standby database

C. the number and size of standby redo logs on the primary database

D. the rate of redo generation on the primary database

E. the number and size of standby redo logs on the standby database

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.

A customer has these requirements for their potential Data Guard implementation:

1. Zero data loss must still be guaranteed through the loss of any one configuration component. 2 The primary database must be protected against a regional disaster

3.

Performance overheads on the primary should be minimized as much as possible given these requirements.

4.

Downtime on the primary database for any reason must be kept to a minimum. Components referred to in the broker commands are:

Which Data Guard broker commands are needed to implement these requirements?

A. EDIT DATABASE prima SET PROPERY REDOROUTES=' (LOCAL: physt1, FASTSYNC)'; EDIT DATABASE prima SET PROPERY REDOROUTES=' (LOCAL: fs1 SYNC)'; EDIT FAR_SYNC fs1 SET PROPERTY REDORUOTES=' (pnma: physt2 SYNC)'; EDIT CONFIGURATION SET PROTECTION MODE AS MAXAVAILABILITY

B. EDIT DATABASE prima SET PROPERY REDOROUTES=' (LOCAL: fs1 ASYNC)'; EDIT FAR_SYNC fs1 SET PROPERTY REDORUOTES=' (prima physt FASTSYNC)'; EDIT CONFIGURATION SET PROTECTION MODE AS MAXPROTECTION

C. EDIT DATABASE prima SET PROPERY REDOROUTES^' (LOCAL: fs1 SYNC)'; EDIT FAR_SYNCfs1 SET PROPERTY REDORUOTES=' (prima physt ASYNC)'; EDIT CONFIGURATION SET PROTECTION MODE AS MAXAVAILABILITY;

D. EDIT DATABASE prima SET PROPERY REDOROUTES=' (LOCAL: physt1, FASTSYNC)'; EDIT DATABASE prima SET PROPERY REDOROUTES= (LOCAL: fs1.

FASTSYNC)'; EDIT FAR_SYNC fs1 SET PROPERTY REDORUOTES=' (prima: physt2 ASYNC)'; EDIT CONFIGURATION SET PROTECTION MODE AS MAXAVAILABILITY;

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.

A data file on one of your physical standby databases has been accidentally deleted and you must restore and recover it. All the archive logs required for recovery are still on disk in the directory pointed to by the log_archive_dest_1 parameter Which three steps must be performed to restore the missing file and recover the standby database while it is in the MOUNT state?

A. Recover the datafile by using the RMAN RECOVER DATAFILE command

B. Restart the redo apply.

C. Restore the datafile by using the RMAN RESTORE DATAFILE command.

D. Stop the redo apply.

E. Recover the database by using the RMAN RECOVER DATABASE command.

Which three statements are true about snapshot standby databases?

A. Snapshot standby databases may be used for rolling release upgrades.

B. if datafiles grow while a database is a snapshot standby database, then they shrink when converted back to a physical standby database.

C. Flashback logs are used to convert a snapshot standby database back into a physical standby database.

D. a snapshot standby database can have Real-Time Query enabled

E. A guaranteed restore point is created automatically when a physical standby database is converted into a snapshot standby database.