1Z0-066 Exam Training Practice Tests (Oracle Database 12c: Data Guard Administrator)]

Question 1

You edit the DGConnectIdentifier database property using the edit database set property DGMGRL command.
Which two are effects of this change? (Choose two.)

A. The fal_client database initialization parameter on all standby databases is updated with the new value. B. The service attribute of the log_archive_dest_n initialization parameter for any database referring to the specified database is updated with the new value. C. The broker configuration must be disabled and then enabled to use the new connection property. D. The service attribute of the log_archive_dest_n initialization parameter referring to all standby databases is updated with the new value. E. The fal_client database initialization parameter for the specified database is updated with the new value.

Correct Answer: A,B

Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).

Question 2

Which two are true about rolling release upgrades in a Data Guard environment? (Choose two.)

A. A physical standby database can be converted to a logical standby database temporarily. B. The recovery point objective increases proportionally to the duration of the rolling release upgrade procedure. C. The background process DMON must be enabled on the primary and standby databases during a rolling release upgrade procedure. D. The KEEP IDENTITY clause ensures that a logical standby database keeps the same DBID as the primary database. E. Rolling release upgrades require the background process RVWR to write flashback logs on the standby database.

Correct Answer: A,D

Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).

Question 3

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? (Choose two.)

A. It allows logical corruptions on the primary to be recovered by using the physical standby database. B. It specifies a delay before the primary ships redo to the standby destination having DelayMins set. C. It can only be enabled for a configuration in Maximum Performance mode. D. It allows user errors on the primary to be recovered by using the physical standby database. E. It enables you to bypass the default network timeout interval specified for the standby redo transport destination. F. It can only be enabled for a configuration in Maximum Availability mode.

Correct Answer: B,D

Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).

Question 4

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

A. Configure Oracle Net connectivity on the primary host to the standby database instance. B. Startup nomount the standby database instance. C. Set the DB_UNIQUE_NAME parameter on the primary database to a different value than that of the DB_NAME parameter. D. Establish user equivalence for the database software owner between the primary host and standby host. E. Put the primary database into archivelog mode.

Correct Answer: A,B,D

Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).

Question 5

A customer asks you to propose the most appropriate solution for this set of requirements:
1. We need a disaster recovery solution that enables us to fail over from our production database with zero data loss.
2. We want to generate reports from the proposed standby database at the same time that it is used for other purposes.
3. Developers may need to test occasionally on a copy of the live database.
You have already confirmed that there are no unsupported data types on the primary database.
Which two solutions would you recommend? (Choose two.)

A. a read mostly implementation of a physical standby database B. a logical standby database C. a remote physical standby database with RedoRoutes via a far sync instance D. a physical standby database with real-time query enabled E. a snapshot standby database with synchronous redo transport

Correct Answer: D,E

Question 6

Which two are true about the usage of DBMS_ROLLING? (Choose two.)

A. The trailing group contains the original primary database. B. The leading group contains the original primary database. C. The trailing group can contain standby databases that will protect the original primary database during the rolling release upgrade process. D. The background process DMON must be enabled on all database instances that take part in the rolling release upgrade process. E. At least one logical standby database must be part of the initial Data Guard configuration.

Correct Answer: C,E

Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).

Oracle Database 12c: Data Guard Administrator - 1Z0-066 Exam Practice Test