Oracle Database 19c: Data Guard Administration - 1z1-076 Free Exam Questions

A. 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.

B. 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.

C. Set the LOCAL_LISTENER parameter for all the database instance to register services with the default listener on the primary database host.

D. Set DB_NAME and DB_UNIQUE_NAME identically on all databases; modify the connection descriptors on client applications to include all the standby hosts and connect to the database instance using that service name.

A. It automatically starts the DMON process for the database instances that are part of a Data Guard configuration.

B. It automatically adds the primary database to an existing broker configuration when Enterprise Manager Cloud Control is used to create a standby.

C. It can be used to perform failovers and switchovers.

D. It can be used to monitor redo transport and log apply services.

E. It can be used to create and manage standby databases.

A. The data guard broker must be used.

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

C. The database must be in ARCHTVELOG mode.

D. The Data Guard real-time apply feature must be enabled.

E. A fast recovery area must be configured.

A. communicating with dkon processes in other database instances that are part of the broker configuration

B. communicating with the DMON process of the observer to monitor a primary database in case a fast start failover is required

C. performing role transitions when switchover requests are made

D. activating role-based services appropriately in the various database instances of the configuration, based on the database role

E. maintaining information about all members of the broker configuration in binary configuration files.

A. 2, 3, 4, and 5

B. 1 and 2

C. Only requirement 5

D. 1, 2, 3, 4, and 5

E. Only requirement 1

A. Create role based services with the si vet] utility when using clusterware for Oracle RAC databases or Oracle Restart for single instance Oracle databases.

B. Create database services for each database and use event triggers to make sure that services are activated only when the database is in the correct role.

C. Create a static service for each of the databases, register it with the local listener of each database instance, and add connection descriptors on clients to connect to those services.

D. Establish Oracle Net connectivity to the primary database instance from all the standby database instances.

E. Create database services on each of the standby databases, start the services, and add connection descriptors on the clients to connect to those services.

A. 1, 2, 3, 6, and 7

B. 1, 2, and 5

C. 1, 2, 6, and 7

D. 1, 2, 3, 4, 5, 6, and 7

E. 1, 6, and 7

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

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

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

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

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

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

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

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

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

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

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

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

A. Only standby databases can write redo....

B. They are required on a physical standby for real-time apply.

C. It is recommended to have them on the...

D. They are required on a logical standby for real-time apply

E. The LGWR process writes to them on ....

F. They are required only for synchronous redo transport