Oracle Database 19c: Data Guard Administration - 1z0-076 Exam Practice Test

A. Monitoring and managing redo transport services, and log apply services.

B. Create a new physical standby database.

C. Converting physical standby databases to snapshot standby databases.

D. Configuring the standby control file, server parameter file, and data files for a standby database.

E. Define logical standby database skip rules.

F. Automating failover to a specified target standby database.

A. Create a standby control file.

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

C. Create an SPFILE for the standby database.

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

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

A. A Snapshot Standby Database can be a fast-start failover target.

B. A Logical Standby Database can be converted to a Snapshot Standby Database.

C. A Logical Standby Database can cascade redo to a terminal destination.

D. A Physical Standby Database can be converted into a Logical Standby Database.

E. A configuration consisting only of a primary and one or more physical standby databases can support a rolling release upgrade.

A. If datafiles grow while a database is a snapshot standby database, then they shrink when converted back to a physical standby database.

B. A snapshot standby database can be the only standby database in a Maximum Protection Oracle Data Guard configuration.

C. A snapshot standby database must be opened at least once in read-write mode before it can be converted into a physical standby database.

D. Snapshot standby databases may be used for rolling database upgrades.

E. A guaranteed restore point is created automatically when a physical standby database is converted into a snapshot standby database.

A. Physical standby databases retain their current role when you flash back to a point in time before a reinstate occurred which caused this database to become a physical standby.

B. Physical standby databases retain their current role when you flash back to a point in time before the switchover occurred which caused this database to become a physical standby.

C. Logical standby databases retain their current role when you flash back through to a point in time before the switchover occurred which caused this database to become a logical standby.

D. Logical standby database roles are reverted to their original role when you flash back to a point in time before the switchover occurred which caused this database to become a logical standby.

E. Flashback database may not be used to undo a physical standby database activation.

A. They can be used to skip ALTE1 STEM and ALTER DATABASE commands.

B. They can only be used to skip DML statements on a table.

C. They can be used to stop SQL apply if it encounters an error.

D. They can be used to skip all SQL statements executed on a specific pluggable database (PDB) within a standby multitenant container database (CDB).

E. They can be used to skip ALTER TABLE commands on specific tables.

F. They can be used to skip CREATE TABLE commands.

G. They can be used to skip execution of DML triggers on a table while allowing the DML to execute.

A. All broker actions execute at the root container for container databases.

B. After a role change, the broker opens all Pluggable databases (pdbb) on the new primary.

C. If the primary database is a container database, then a logical standby may be a non-container database.

D. If the primary database is not a container database, then a standby may be a container database.

E. If the primary database is a container database, then a physical standby may be a non-container database.

A. Increase the size of the buffer cache on the standby database instance.

B. Change the protection mode to Maximum Protection.

C. Reduce I/O latency for the storage used by the primary database.

D. Increase the number of standby redo log files on the primary database.

E. Increase the network bandwidth between the primary and standby databases.

F. Change the protection mode to Maximum Performance.