Oracle 1z0-076 問題集

質問 1：
In Oracle Database 19c, you can set the value of database initialization parameters in a database using the EDIT DATABASE... SET PARAMETER Command:
DGMGRL> EDIT DATABASE 'boston' SET PARAMETER log_archive_trace - 1;
Which THREE statements are TRUE about the command?
A. The database must be available when the above command is run.
B. The value set using this command is directly applied to the boston database.
C. The EDIT DATABASE PARAMETER command can be used to set the value of a static parameter in a database.
D. The value set using this command is directly stored in the broker configuration file.
E. The edit database parameter command can only be used to modify the value of a dynamic parameter in a database.
正解：A,B,E
解説: (Topexam メンバーにのみ表示されます)

質問 2：
Which three are prerequisites for enabling Fast-Start Failover?
A. You can specify only one standby database as the fast-start failover target.
B. The configuration must be operating in either Maximum Performance or Maximum Protection mode.
C. Flashback Database must be enabled only on the Fast-Start Failover target standby database.
D. The Data Guard environment must be managed by the Data Guard Broker.
E. Flashback Database must be enabled on both the primary database and the Fast-Start Failover target standby database.
F. The maximum protection mode can be used, but with two or more standby databases.
正解：A,D,E
解説: (Topexam メンバーにのみ表示されます)

質問 3：
On your logical standby database, you specified these rules:

After completion of the weekend batch cycle you attempt to delete the SQL Apply filters:

Which is TRUE regarding the execution of the UNSKIP procedure?
A. It succeeds only if SQL apply is stopped before deleting the SQL Apply filter.
B. It succeeds only if all DML statements executed on the primary have been applied on the logical standby deleting the SQL Apply filter.
C. It succeeds but the SQL Apply filters are not deleted.
D. It deletes both the SQL Apply filters.
E. It returns an error because the syntax to delete a SQL Apply filter must specify the same object names as specified when the filter was added.
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 4：
Which two are true about managing and monitoring Oracle container databases in a Data Guard environment using the broker?
A. If the primary database is not a container database, then a standby may be a container database.
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 physical standby may be a non-container database.
D. If the primary database is a container database, then a logical standby may be a non-container database.
E. All broker actions execute at the root container for container databases.
正解：B,E
解説: (Topexam メンバーにのみ表示されます)

質問 5：
Which three are prerequisites for using Data Guard Broker?
A. A statically defined listener end-point must be registered with the local listener on the servers hosting the standby database instances.
B. The broker configuration files for a RAC database must reside in shared storage accessible by all the RAC database instances.
C. The primary and standby databases must run the same version of the Oracle Database server.
D. Network connectivity to the primary database instance must be defined on the servers hosting the standby database instances.
E. DG_BROKEB_START must be set to TRUE for a database instance before adding the database to the broker configuration.
F. If any database in the configuration is a RAC database, then the broker configuration files must reside in shared storage accessible by all database instances for all databases in the broker configuration.
正解：C,D,F
解説: (Topexam メンバーにのみ表示されます)

質問 6：
Examine the Data Guard configuration:
DGMGRL> show configuration;
Configuration - Animals
Protection Mode: Max Availability
Databases:
dogs - Primary database sheep
- Physical standby database cats
- Physical standby database
Fast-Start Failover: DISABLED
Configuration Status: SUCCESS
An attempt to enable fast-start failover raises an error:
DGMGRL> enable fast_start failover;
Error: ORA-16693: requirements not met for enabling fast-start failover Failed.
Identify three possible reasons for this error.
A. The fastStartFailoverTarget property is not set on Dogs.
B. The LogXptMode property is set to FASTSYNC on Cats while Sheep is the target standby database.
C. The LogxptModr property is set to async on Sheep while Sheep is the target standby database.
D. The LogXptMode property is set to fastsync on Dogs.
E. The LogXptMode property is set to async on Dogs.
正解：A,C,E
解説: (Topexam メンバーにのみ表示されます)

質問 7：
Which three statements are true....... With no Oracle Streams or Goldengate configured?
A. They are required only for synchronous redo transport
B. It is recommended to have them on the...
C. They are required on a logical standby for real-time apply
D. They are required on a physical standby for real-time apply.
E. Only standby databases can write redo....
F. The LGWR process writes to them on ....
正解：C,D,F
解説: (Topexam メンバーにのみ表示されます)