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 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 two are prerequisites for creating a standby database using Enterprise Manager cloud control?

A. The primary database must have FORCE LOGGING enabled.

B. The primary database must be in archive log mode

C. A backup of the primary database must exist.

D. The primary host and the proposed standby database host must run the same operating system.

E. The primary database instance must be started using an SPFILE.

F. The primary database must have flashback enabled

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

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.