Oracle Database 12c Data Guard Administration

Here you have the best Oracle 1z0-066 practice exam questions

You have 102 total questions to study from
Each page has 5 questions, making a total of 21 pages
You can navigate through the pages using the buttons at the bottom
This questions were last updated on December 29, 2024

Question 1 of 102

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

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

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

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

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

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

Correct Answer: B, D

In a Data Guard environment with multi-tenant databases, each pluggable database (PDB) within a multi-tenant physical standby database has at least one associated Oracle Net service name. This ensures connectivity and service management. Additionally, a PDB within a multi-tenant standby database can indeed have a different open mode than the container database (CDB), allowing for more flexible management of individual PDBs. Other options are incorrect as DB_UNIQUE_NAME is specified at the CDB level and not modifiable for individual PDBs, MRP processes run on the CDB level, and the database role is defined at the CDB level, not individually for each PDB.

Question 2 of 102

Your Data Guard environment has two remote physical standby databases.

Client applications use the local naming method to connect to the primary database instance.

You want applications to automatically connect to the new primary database instance in case of a switchover or a failover.

Which will fulfill this requirement?

Create a database service on each standby database that is started automatically by a trigger, when the database role is PRIMARY; modify the connection descriptors used by client applications to include all the standby hosts and connect to the database instance using that service name.

Create a database service on the primary database that is started automatically by a trigger, when the database role is PRIMARY; modify the connection descriptors used by client applications to include all the standby hosts and connect to the database instance using that service name.

Set the INSTANCE_NAME parameter identically on all databases; modify the connection descriptor on client applications to include all the standby hosts and connect to the database instance using that service name.

Set the DB_NAME and DB_UNIQUE_NAME identically on all databases; modify the connection descriptors on client applications to include all the standby

Correct Answer: B

To fulfill the requirement of having client applications automatically connect to the new primary database instance in case of a switchover or failover, you should create a database service on the primary database that is started automatically by a trigger when the database role is PRIMARY. The connection descriptors used by client applications should then include all the standby hosts and connect to the database instance using that service name. This ensures that the service is appropriately available only when the database assumes the primary role, facilitating automatic reconnection by client applications.

Question 3 of 102

Examine the Data Guard configuration:

DGMGRL > show configuration;

Configuration-Animals -

Protection Mode: MaxPerformance -

Databases:

dogs-Primary database

sheep-Snapshot standby database

cats-Snapshot standby database

Fast-Start Failover: DISABLED -

Configuration Status:

SUCCESS -

You receive an error while attempting to raise the protection mode to Maximum Availability:

DGMGDRL> edit configuration set protection mode as maxavailability;

Error: ORA-16627: operation disallowed since no standby databases would remain to support protection mode

Failed.

Identify two statements that you can execute, either one of which will enable successful raising of the protection mode to Maximum Availability.

DGMGRL> convert database sheep to physical standby;

DGMGRL> convert database cats to physical standby;

DGMGRL> edit database dogs set property LogXptMode= fastsync;

DGMGRL> edit database sheep set property LogXptMode= fastsync;

DGMGRL> edit database cats set property LogXptMode= sync;

Correct Answer: A, B

To set the protection mode to Maximum Availability, at least one of the standby databases must be a physical standby database and configured appropriately. In the current configuration, both 'sheep' and 'cats' are snapshot standby databases, which cannot support Maximum Availability. Therefore, converting either 'sheep' or 'cats' to a physical standby database using the command 'convert database sheep to physical standby;' or 'convert database cats to physical standby;' will resolve the issue and enable raising the protection mode to Maximum Availability.

Question 4 of 102

You administer a Data Guard environment with a primary and two physical standby databases.

One of the physical standby databases is used for reporting and is on the same host as the primary database.

The other physical standby database is remote, used for disaster recovery and REDO is routed to it via a far sync instance.

Backups are offloaded to the remote physical standby.

Which three are true concerning the management of archive logs in this Data Guard configuration?

Archive logs on the primary database may be deleted once they are applied on all standby databases.

Archive logs on the primary database may be deleted once they are shipped on all standby databases.

The deletion policy for archive logs on the remote physical standby should be set so that archived logs are deleted once they backed up at least once on the remote physical standby database.

The deletion policy for archive logs on the remote physical standby should be set so that archived logs are deleted once they are applied on all standby databases.

Archive logs on the primary database may be deleted once they are archived locally to disk.

Correct Answer: A, B, C

In this Data Guard configuration, archive logs on the primary database may be deleted once they are applied on all standby databases to ensure that all standby databases have the necessary logs for synchronization and recovery. This ensures data consistency across the environment (A). Similarly, primary database archive logs may be deleted once they are shipped to all standby databases, as this indicates successful transmission (B). Lastly, the deletion policy for archive logs on the remote physical standby should be set so that archived logs are deleted once they are backed up at least once on the remote physical standby database to ensure that all critical data is securely stored before deletion (C).

Question 5 of 102

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

A flash recovery area must be configured.

The database must be in MOUNT state.

The database must be in ARCHIVELOG mode.

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

The Data Guard Broker must be used.

Correct Answer: A, C

To configure flashback database for Oracle 12c databases in a Data Guard environment, certain prerequisites must be met. Firstly, a flash recovery area must be configured because flashback logs can only be stored there. Secondly, the database must be in ARCHIVELOG mode since archived logs are integral to performing flashback operations.