Create Next App

Exam contains 108 questions

Page 5 of 18

Question 25 🔥

After converting your physical standby database to a logical database, you get an error:DGMGRL> show configuration -Configuration- proddg -Protection Mode: MaxPerformance -Databases:prod-Primary datatabseprodsby-Physical standby databaseError: ORA-16810 multiple errors or warnings detected for databaseFast-Start Failover: DISABLED -Configuration Status:ERROR -How can you rectify the error?

Which database solution meets these requirements?

A. Add a logical standby database PRODSBY and enable it, thereby replacing the physical standby database metadata in the broker configuration.

Highly voted

B. Remove the physical standby database PRODSBY from the broker configuration, add a logical standby database PRODSBY to the broker configuration and enable it.

Highly voted

C. Reinstate the physical standby database PRODSBY as a logical standby, thereby replacing the physical standby database metadata in the broker configuration.

Highly voted

D. Reinstate both the primary and physical standby databases. The broker will automatically detect that PRODSBY is a logical standby update to the metadata.

Highly voted

Discussion of the question

Question 26 🔥

Which four requirements can be met by deploying a logical standby database?

Which database solution meets these requirements?

A. Support for workloads requiring additional indexes.

Highly voted

B. It can be used to create additional schemas.

Highly voted

C. It can be used to create additional tables.

Highly voted

D. It must have the same physical structure as the primary database.

Highly voted

E. it must provide a disaster-recovery solution that protects all data with capability of performing switchovers and failovers.

Highly voted

F. Support for workloads requiring additional materialized views.

Highly voted

G. It can be used for Real Application Testing without affecting the disaster recovery capabilities.

Highly voted

Discussion of the question

Question 27 🔥

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?

Which database solution meets these requirements?

A. The upgrade requires downtime until the upgrade of the standby is completed.

Highly voted

B. The broker must be disabled during the upgrade.

Highly voted

C. With manual upgrade, catupgrd.sq1 can be executed on the primary and standby databases simultaneously.

Highly voted

D. The upgrade requires downtime until the upgrade of the primary is completed.

Highly voted

E. The new release of the Oracle Software must be installed on both the primary and standby database hosts.

Highly voted

F. Redo Apply on the standby database must be stopped while the primary database is upgraded.

Highly voted

G. Fast-Start Failover can be used to protect the primary database during the upgrade.

Highly voted

Discussion of the question

Question 28 🔥

You are licensed to use Oracle Active Data Guard.Which two statements are true after enabling block change tracking on a physical standby database?

Which database solution meets these requirements?

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

Highly voted

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

Highly voted

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

Highly voted

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

Highly voted

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

Highly voted

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

Highly voted

Discussion of the question

Question 29 🔥

Which three are true regarding the Enterprise Manager Cloud Control Data Guard configuration verification wizard?

Which database solution meets these requirements?

A. It checks that supplemental logging is turned on if there is a logical standby database in the configuration.

Highly voted

B. It verifies that parameter settings in the SPFILE or in memory or both, are consistent with the broker configuration properties for that database.

Highly voted

C. It checks that the current data protection level is consistent with the broker’s configured data protection mode.

Highly voted

D. It modifies the database configurable parameters to match the values set for the broker configuration.

Highly voted

E. It generates a workload on the primary database causing log switching, and monitors the arrival rate of redo on the standby database.

Highly voted

Discussion of the question

Question 30 🔥

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

Which database solution meets these requirements?

B. Each pluggable database within a multi-tenant physical standby database has a minimum of one associated Oracle Net service name.

Highly voted

C. Each pluggable database within a multi-tenant physical standby has one MRP background process running during redo apply.

Highly voted

D. A pluggable database within a multi-tenant standby database can have a different open mode than the container database.

Highly voted

E. A pluggable database within a multi-tenant standby database can have a different database role than the container database.

Highly voted

A. DB_UNIQUE_NAME must be specified differently for each pluggable database within a multi-tenant standby database.

Highly voted

Discussion of the question

Ready to Pass Your Certification Test

oracle 1Z0_066

Exam contains 108 questions

Lorem ipsum dolor sit amet consectetur. Eget sed turpis aenean sit aenean. Integer at nam ullamcorper a.

Company

Product

Resources

Follow us