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

Which four are true about DGMGRL show command?

A. It can be used to show properties of a pluggable standby database.

B. it can be used to show properties of a pluggable primary database.

C. it can be used to show instance-specific properties for a RAC database.

D. it can be used to show properties of a far sync instance

E. it can be used to show Fast Start Failover properties.

F. It can be used to show properties of a primary container database.

Which three steps are prerequisites for the creation of a physical standby database on a separate server using the RMAN active database duplication method?

A. Set the DB_UNIQUE_NAME parameter on the primary database to a different value than that of the DB_NAME parameter.

B. Put the primary database into archivelog mode

C. Startup nomount the standby database instance.

D. Configure Oracle Net connectivity on the primary host to the standby database instance.

E. Establish user equivalence for the database software owner between the primary host and standby host.

Your Data Guard environment consists of these components and settings:

1. A primary database supporting an OLTP workload 2 A remote physical standby database

3.

Real-time query is enabled

4.

The redo transport mode is set to SYNC.

5.

The protection mode is set to Maximum Availability

Which two are true regarding the DelayMins Database Property for the standby database?

A. it can only be enabled for a configuration in Maximum Performance mode.

B. It allows user errors on the primary to be recovered by using the physical standby database.

C. It enables you to bypass the default network timeout interval specified for the standby redo transport destination.

D. it can only be enabled for a configuration in Maximum Availability mode.

E. It allows logical corruptions on the primary to be recovered by using the physical standby database.

F. It specifies a delay before the primary ships redo to the standby destination having DelayMins set.

Attempting to start the observer raises an error

DGMGRL> start observer:

DGM-16954 Unable to open and lock the Observer configuration file Failed.

Identify two possible ways to start the observer successfully

A. Set the Observer Override property to TRUE before starting the observer

B. Create a broker configuration and enable Fast-Start Failover before starting the observer

C. Start the observer using a different observer configuration file.

D. start the observer in a different working directory.

E. Enable Fast-Start Failover before starting the observer

Examine the Data Guard configuration:

Which three will be true after a switchover to Sheep?

A. Cats will be an enabled logical standby database

B. Cats will be a disabled logical standby database.

C. Dogs will be a logical standby database.

D. Dogs will be a physical standby database

E. Sheep will be the primary database.

Which two are prerequisites for configuring flashback database for Oracle 12c databases, in a Data Guard environment?

A. a flash recovery area must be configured

B. The database must be in MOUNT state.

C. The database must be in ARCHIVELOG mode.

D. A far sync instance must be configured to flash back a standby when the primary has been flashed back.

E. The Data Guard Broker must be used.

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

Which two are true about rolling release upgrades in a Data Guard environment?

A. The background process DMON must be enabled on the primary and standby databases during a rolling release upgrade procedure

B. A physical standby database can be converted to a logical standby database temporarily.

C. Rolling release upgrades require the background process RVWR to write flashback logs on the standby database.

D. The KEEP IDENTITY clause ensures that a logical standby database keeps the same DBID as the primary database.

E. The recovery point objective increases proportionally to the duration of the rolling release upgrade procedure.

Which two statements are true about block media recovery in a Data Guard environment? (Choose two.)

A. When using RMAN, the RECOVER CORRUPTION LIST command can automatically use blocks from flashback logs.

B. A corrupt block on the primary database can be recovered automatically, using blocks from a physical standby database that has the Real-Time Query enabled.

C. DB_LOST_WRITE_PROTECT must be set to TYPICAL to enable Automatic Block Media Recovery.

D. When using RMAN, the RECOVER CORRUPTION LIST command can use blocks from change tracking files.

E. DB_LOST_WRITE_PROTECT must be set to FULL to enable Automatic Block Media Recovery.

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

Which two are true concerning the configuring of Flashback database in a Data Guard environment? (Choose two.)

A. It enables the use of far sync instances.

B. It is a prerequisite for the use of Fast Start Failover.

C. It permits a primary database that was disabled after failover to be reinstated as a standby.

D. It permits a physical standby database to be converted to a snapshot standby database.

E. It is required in order for a snapshot standby database to be converted to a physical database.

Which three are true about the use of the VALID_FOR clause of the LOG_ARCHIVE_DEST_N parameter, in determining whether archive logs should be written to a particular destination by a database in a Data Guard environment? (Choose three.)

A. whether the database at the destination is reached by using a far sync instance

B. whether the database at the destination is a primary or a standby

C. whether online redo logs are to be archived at a specific destination

D. whether standby redo logs are to be archived at a specific destination

E. whether the database at the source is a primary or a standby