Oracle 1z0-076 問題集

質問 1：
Which TWO statements are true regarding Data Guard Broker?
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 create and manage standby databases.
D. It can be used to perform failovers and switchovers.
E. It can be used to monitor redo transport and log apply services.
正解：C,D

質問 2：
Which TWO statements are true about configuring Oracle Net Service in a Data Guard environment?
A. A static service must be registered with the local listener to enable DGMGRL to restart instances during the course of broker operations.
B. Enterprise Manager does not require static service registration to restart instances during the course of broker operations.
C. Installing the oracle-database-preinstall-19c package is NOT sufficient to set up operating system kernel parameters for Oracle Net.
D. It is necessary to use the failover clause for an address_list with multiple address lists in the tnsnames.ora file.
E. Install the oracle-database-preinstall-19c package to set the kernel parameters for Oracle Net based on the Data Guard best practice guidelines.
正解：A,C
解説: (Topexam メンバーにのみ表示されます)

質問 3：
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 no BFILE LOB data types are contained in the primary database.
C. Ensure that flashback is enabled on the primary database.
D. Ensure that no ROWID data types are contained in the primary database.
E. Do not perform any nologging operations on the primary.
正解：A,B,E

質問 4：
Which TWO statements are true for Data Guard environments with multi-tenant databases?
A. The Data Guard broker automatically opens all pluggable databases of a primary database after a role change operation.
B. The CDBDBA privilege must be used instead of the SYSDBA privilege for connections as SYS to the root container of a multi-tenant standby database.
C. Different pluggable databases within a logical standby database may have different guard statuses.
D. The Data Guard broker automatically always opens the pluggable databases of a standby database after a role change operation.
E. A multi-tenant standby database can have fewer pluggable databases than the primary container database.
正解：C,E

質問 5：
Which three Data Guard monitoring activities may be performed using Enterprise Manager Cloud Control?
A. You can set a warning threshold on the redo generation rate metric for a physical standby database.
B. You can monitor the redo apply rate on a logical standby database.
C. You can check if redo apply needs to be tuned.
D. You can check the potential data loss in the event of a disaster.
E. You can set a critical threshold on the redo generation rate metric for a primary database.
F. You can monitor the redo apply rate on a snapshot standby database.
正解：B,D,E

質問 6：
Which TWO statements correctly describe the behavior of Automatic Block Media Recovery in a Data Guard environment, for a corrupt block in the example tablespace encountered by a session logged in as the SH user?
A. A corrupt block on the primary database is automatically recovered, using a block from a flashback log from a standby database with Real-Time Query enabled.
B. A corrupt block on the primary database is automatically recovered, using a block from a flashback log from the primary database.
C. A corrupt block on the primary database can be automatically recovered, using a block from a standby database with Real-Time Query enabled.
D. A corrupt block on a standby database with Real-Time Query enabled, can be automatically recovered, using a block from the primary database.
E. A corrupt block on a standby database with Real-Time Query enabled, is automatically recovered, using flashback logs from the standby database.
正解：B,C
解説: (Topexam メンバーにのみ表示されます)

質問 7：
You are monitoring your Data Guard broker configuration and issue this set of DGMGRL commands:
DGMGRL> SHOW CONFIGURATION;
Configuration - DRSolution
Protection Mode: MaxPerformance
Databases:
Close_by - Primary database
FS_inst - Far Sync
Far_away - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
What is true concerning this configuration?
A. The FS_inst Far Sync instance forwards redo to the Far_away physical standby only if the Close_by primary database is not able to do so.
B. The Far Sync instance will not forward redo to the Far_away physical standby because Fast-Start Failover is disabled.
C. The Close_by primary database forwards redo to the Far_away physical standby directly and also sends redo to the FS_inst Far Sync instance.
D. The Close_by primary database instance forwards redo to the FS_inst Far Sync instance, which forwards the redo in turn to the Far_away physical standby database instance.
E. The Far Sync instance will not forward redo to the Far_away physical standby because the Protection mode is not MaxProtection.
正解：D