Oracle Database 19c: Data Guard Administration (1z1-076) Free Practice Test

Question 1

Examine the Data Guard configuration:
DGMGRL> show configuration;
Configuration - Animals
Protection Mode: MaxAvailability
Databases:
dogs - Primary database
sheep - Snapshot standby database
cats - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
You receive an error while attempting to raise the protection mode to Maximum Protection:
DGMGRL> edit configuration set protection mode as maxprotection;
Error: ORA-16627: operation disallowed since no standby databases would remain to support protection mode Failed.
Which is the minimum statement, or sequence of statements you must execute to enable successful raising of the protection mode to Maximum Protection?

A. DGMGRL> edit database dogs set property LogXptMode=sync;
DGMGRL> edit database sheep set property LogxptMode=sync;
DGMGRL> edit database cats set property LogXptMode=sync;

B. DGMGRL> edit database cats set property LogXptMode=sync;

C. DGMGRL> edit database sheep set property LogXptMode=sync;

D. DGMGRL> edit database dogs set property LogxptMode=sync;

E. DGMGRL> edit database dogs set property LogXptMode=sync;
DGMGRL> edit database cats set property LogXptMode=sync;

F. DGMGRL> edit database dogs set property LogxptMode=sync;
DGMGRL> edit database sheep set property LogxptMode=sync;

Correct Answer: E

Question 2

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

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

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

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

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

E. It enables the use of far sync instances.

Correct Answer: B,C

Question 3

Which two are true about the use of RMAN recovery catalogs when offloading backups to a physical standby database?

A. The physical standby database may be used to register the database in the recovery catalog, if the primary is not registered.

B. It backups that are offloaded to a physical standby database are taken when not connected to a recovery catalog, then they may still be used for restoration on the primary database.

C. Primary and physical standby databases may use different virtual recovery catalogs in the same physical recovery catalog.

D. The primary and physical standby databases must be registered separately in the recovery catalog, if a far sync instance is used to route redo to the physical standby database.

E. It is not necessary to use a recovery catalog unless a far sync instance is used to route redo to the physical standby database.

Correct Answer: B,C

Question 4

Which two steps must be performed before running DUPLICATE TARGET DATABASE FOR STANDBY using RMAN?

A. Run the nid utility to modify the DBID of the primary database.

B. Configure Oracle Net connectivity between the primary host and the standby host.

C. Create an SPFILE for the standby database.

D. Create a standby control file.

E. Transfer a copy of the password file from the primary host to the standby host.

Correct Answer: B,E

Question 5

Examine the following parameter settings of the physical standby database:
* STANDBY_FILE_MANAGEMENT=AUTO
* ENABLED_PDBS_ON_STANDBY=<null>
During which TWO tasks are files automatically created in the physical standby database after structure changes on the primary database?

A. Adding a data file or creating a tablespace

B. Performing transportable tablespaces

C. Adding or dropping a redo file group

D. Renaming a data file in the primary database

E. Creating a PDB from the existing PDB within the same CDB

Correct Answer: A,E

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

Question 6

Which three are true regarding prerequisites for a logical standby database as a disaster recovery solution?

A. Ensure that supplemental logging is enabled on the primary database.

B. Ensure that flashback is enabled on the primary database.

C. Do not perform any nologging operations on the primary.

D. Ensure that no BFILE LOB data types are contained in the primary database.

E. Ensure that no ROWID data types are contained in the primary database.

Correct Answer: A,C,D

Welcome to TestSimulate

Oracle Database 19c: Data Guard Administration (1z1-076) Free Practice Test