1z1-076 無料問題集「Oracle Database 19c: Data Guard Administration」

（A）Synchronous redo transport mode connections to the standby database are terminated.

（B）The physical standby database instance is shut down by the Data Guard broker.

（C）Real-time query will be disabled on the physical standby.

（D）The protection mode will automatically change to Maximum Performance.

（A）Adding a database to the Sales configuration with DGMGRL requires that the Sales configuration be disabled first. It must then be enabled after the new database is added to the configuration.

（B）DGMGRL may be used to add the Sales configuration to the Prod pool in gds.

（C）Performing a role change with DGMGRL automatically notifies GDS which in turn activates the appropriate services.

（D）DGMGRL may be used to add a single database to the Sales configuration even if Sales is a member of the Prod pool.

（E）Adding a database to the Sales configuration with DGMGRL automatically adds the database to the Prod Pool.

（A）You can check the potential data loss in the event of a disaster.

（B）You can check if redo apply needs to be tuned.

（C）You can monitor the redo apply rate on a snapshot standby database.

（D）You can set a critical threshold on the redo generation rate metric for a primary database.

（E）You can set a warning threshold on the redo generation rate metric for a physical standby database.

（F）You can monitor the redo apply rate on a logical standby database.

（A）Logical standby databases can be the target database for the dbms_dbcomp.dbcomp procedure.

（B）The databases should be at least mounted before block comparison.

（C）You can monitor the progress of an ongoing block comparison operation by querying VS SES SION_LONGOPS.

（D）It requires that the DB_LOST_WKITE_protect initialization parameter be enabled.

（E）It can be used to detect lost writes and inconsistencies between the primary database and the cascaded standbys.

（A）If the former primary database became a logical standby database it will be open read-write.

（B）If the former primary database became a logical standby database it will be in mount state.

（C）The former primary database will always be open.

（D）If the former primary database became a physical standby database it will always be open readonly.

（E）If the former primary database became a physical standby database it will be in the same state as the former physical standby database.

（F）The new primary database will be open read-write.

（A）Read-mostly reporting applications that use global temporary tables for storing temporary data can be offloaded.

（B）PL/SQL blocks that you run on Active Data Guard standby databases can be always redirected to and run on the primary database.

（C）The DML operations on a standby can be transparently redirected to and run on the primary database

（D）The DDL operations on private temporary tables are transparently redirected to the primary database.

（E）You might have to use sequences with global temporary tables to support read-mostly applications by using Active Data Guard.

（A）Client TNS entries for the databases use the correct service names for the intended service.

（B）Oracle Net connectivity to the primary database instance must be established on all the standby database instances.

（C）The standby database services must be defined statically with the Listeners running on the standby database hosts.

（D）The LOCAL_LISTENER parameter on the primary database instance must always be set.

（E）The client applications must use the correct TNS entries when requesting connections to the database instances.

（F）A service name is registered with the local listener of each database instance.

（G）The DB_NAME and DB_UNIQUE_NAME parameters must be set to the same value for all the databases in the Data Guard environment.