1Z0-066 Online Practice Questions and Answers

Which two statements are true about Real-Time Query?

A. Setting STANDBY_MAX_DATA_DELAY =0 requires synchronous redo transport.

B. Disabling Real-Time Query prevents the automatic start of redo apply when a physical standby database is opened READ ONLY.

C. Real-Time Query sessions can be connected to a Far Sync instance.

D. Real-Time Query has no limitations regarding the protection level of the Data Guard environment.

E. A standby database enabled for Real-Time Query cannot be the Fast-Start Failover target of the Data Guard configuration.

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 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

You are monitoring your Data Guard broker configuration and issue this set of DGMGRL commands:

What is true concerning this configuration?

A. The Close_by primary database instance forwards redo to the FSjnst Far Sync instance, which forwards the redo in turn to the Far_away physical standby database instance.

B. The far sync instance will not forward redo to the Far_away physical standby because the Protection mode is not MaxProtection.

C. The close_by primary database forwards redo to the Far_away physical standby directly and also sends redo to the FSjnst Far Sync instance.

D. The far sync instance will not forward redo to the Far_away physical standby because Fast-Stan: Failover is disabled

E. The FSjnst Far Sync instance forwards redo to the Far_away physical standby only if the close_by primary database is not able to do so.

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

A. Real Time Query must be enabled on the primary database

B. Real Time Query must be enabled on the physical standby database.

C. |f a physically corrupt block is discovered on a physical standby database, then a valid block image from the primary database is retrieved.

D. If a physically corrupt block is discovered on the primary database, then a valid block image from a physical standby database is retrieved

E. if a physically corrupt block is discovered on a logical standby database, then a valid block image from the primary database is retrieved.

F. If a physically corrupt block is discovered on a primary database, then a valid block image from the logically standby database is retrieved.

Which two are true about offloading backups to a physical standby database in a Data Guard environment?

A. The standby database must be registered in an RMAN catalog after the primary database has been registered

B. The standby database cannot be registered in an RMAN catalog if the primary database has not been registered

C. Backups of the standby control file taken while connected to the catalog where the database is registered, may be used to restore the control file on the primary database.

D. The standby database must be registered in an RMAN catalog before the primary database has been registered

Which three statements are true about Global Sequences when connected to a physical standby database with Real-Time Query enabled?

A. if the CACHE option is set then the size of the cache must be at least 100

B. Their creation requires that a LOG_ARCHIVE_DEST_n parameter be defined in the standby that points back to their primary

C. Their usage will always have a performance impact on the primary database.

D. Their usage may have a performance impact on the physical standby database if the CACHE size is too small

E. They must have the NOORDER and CACHE options set.

You are licensed to use Oracle Active Data Guard

Which two statements are true after enabling block change tracking on a physical standby database?

A. it allows fast incremental backups to be offloaded to the physical standby database

B. It starts the CTWR process on the physical standby database instance

C. it allows fast incremental backups to be taken on the primary database.

D. It starts the RVWR process on the physical standby database instance.

E. It allows fast incremental backups to be offloaded to a snapshot standby database, when the physical standby database in converted.

F. It starts the CTWR process on the primary database instance.

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 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

Examine the Data Guard configuration: Identify two possible reasons for this error.

A. The FastStartFailoverTarget property is not set on Sheep.

B. The FastStartFailoverTarget property is not set on Dogs.

C. The FastStartFailoverTarget property is not set on DogsFSI.

D. The LogXptMode property is set to ASYNC on Dogs.

E. The RedoRoutes property is not set on Dogs

F. The RedoRoutes property is not set on DogsFSI

Which two statements are true for Data Guard environments with mufti-tenant databases?

A. Different pluggable databases within a logical standby database may have different guard statuses.

B. The Data Guard broker automatically always opens the pluggable databases of a standby database after a role change operation.

C. The Data Guard broker automatically opens all pluggable databases of a primary database a role change operation.

D. The CDBDBA privilege must be used instead of the SYSDBA privilege for connections as SYS to the root container of a multi-tenant standby database.

E. A multi-tenant standby database can have fewer pluggable databases than the primary container database

Which three are true concerning restoring of RMAN backups to primary and physical standby databases in a Data Guard environment?

A. Backups of data files taken on the primary database may be restored on a physical standby database.

B. Backups of control files taken on the primary database may not be restored and used on a physical standby database.

C. Backups of SPFILEs taken on a physical standby database may not be restored on the primary database.

D. Backups of control files taken on a physical standby database may be restored on the primary database.

E. Backups of data files taken on a physical standby database may be restored on a pnmary database.

F. Backups of SPFILEs taken on the primary database may not be restored and used on a physical standby database.

Which three are benefits of using the Data Guard Broker to manage standby databases?

A. it simplifies physical standby database creation

B. It provides an easy failover capability using a single command.

C. it coordinates database state transitions and updates database properties dynamically.

D. it automatically changes database properties after the protection mode for a configuration is changed

E. It provides an easy switchover capability using a single command.

F. It simplifies logical standby database creation.

You must propose an Oracle Data Guard configuration for a database supporting a DSS workload that meets these permanent requirements:

1.

The performance impact on the primary database should be kept to a minimum.

2.

Creating and maintaining materialized views should not impact the performance of the primary database.

Additionally, there are these requirements, only the one of which is ever done at any one time:

3.

It should be possible to apply designated patches with a minimum amount of downtime.

4.

Upgrading to a new database release should be performed with the least possible amount of downtime.

5.

New application software releases should be tested against an exact up-to-date replica of the production database.

You propose a configuration operating in Maximum Performance mode with a primary database and one logical standby database.

Which requirements do you meet?

A. 1, 2, and 3

B. 2 and 5

C. 1 and 5

D. 1, 2, 3, 4, and 5

E. 1, 2, and 4

F. 2, 3, and 5