Free Oracle 1z0-076 Exam Dumps Questions & Answers

You created the PRODSBY1 physical standby database for the PROD primary database using gql and RMAN. You are planning to create a Data Guard Broker configuration. You execute the command:

Which three statements are true regarding the execution of the command?

• A.  The Data Guard Broker configuration files is automatically created in the destinations specified by the DG_BROKER_CONFIG_FILEn initialization parameters on the primary database.
• B.  The PRODSBY1 standby database is automatically added to the configuration if DG_BROKER_START is TRUE for PRODSBYl.
• C.  The PRODSBYI standby database is automatically added to the configuration if Oracle Net connectivity to the PRODSBYl database instance is defined on the primary host.
• D.  The command will execute successfully only if Oracle Net connectivity to the PROD database instance is defined on the primary host.
• E.  The command will execute successfully only if Oracle Net connectivity to the PROD and PRODSBYl database instances are defined on the primary host.
• F.  The command will execute successfully only if the DG_BROKER_START initialization parameter is set to TRUE for the PROD database instance.

Your current Data Guard environment consists of:
A primary database containing no abstract data types used for user tables.
Two separate remote physical standby databases used for reporting.
Examine these requirements for adding a new standby database to this Data Guard environment:
The new standby database must provide a disaster recovery solution.
There must be minimal additional performance overheads on the primary database.
The new standby database may require additional indexes and materialized views not present in the primary.
New tables or schemas may be required in the standby database that are not present in the primary.
What would you recommend to fulfill these requirements?

• A.  A logical standby database with asynchronous redo transport and SQL apply on.
• B.  A physical standby database with asynchronous redo transport and Real-Time Query enabled.
• C.  A physical standby database with synchronous redo transport and Real-Time Query enabled.
• D.  A logical standby database with synchronous redo transport and SQL apply on.
• E.  A logical standby database with synchronous redo transport and redo apply on.

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 value set using this command is directly stored in the broker configuration file.
• 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 database must be available when the above command is run.
• E.  The edit database parameter command can only be used to modify the value of a dynamic parameter in a database.

Which three are true about using Flashback database through role transitions in a Data Guard environment?

• A.  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.
• B.  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.
• C.  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.
• D.  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.
• E.  Flashback database may not be used to undo a physical standby database activation.

You have a Data Guard broker configuration consisting of:
A primary database
One local physical standby database
One far sync instance
A remote physical standby database
The broker configuration was created with the DGMGRL utility after creating all the databases and the far sync instance with command-line tools.
What is the correct way to add this configuration to Enterprise Manager Cloud Control assuming all the nodes have been discovered already as Enterprise Manager targets?

• A.  Discover the primary as a target by refreshing the node on which it runs, and the other databases and instances in the Data Guard broker configuration will be discovered as targets automatically and be ready to be monitored.
• B.  Delete the Data Guard Broker configuration using DGMGRL and then re-create it using Enterprise Manager Cloud Control to enable all the databases in the configuration to be discovered as targets and to be ready to be monitored.
• C.  Discover the primary database as a target in Enterprise Manager Cloud Control. Then discover the existing Data Guard Broker configuration for the primary and all the other databases in the configuration will be discovered as targets and be ready to be monitored.
• D.  Discover either of the physical standby databases as a target by refreshing the node on which they run, and the other databases and instances in the Data Guard Broker configuration will be discovered as targets automatically and be ready to be monitored.
• E.  Use the DGMGRL utility to register the configuration with the Enterprise Manager Cloud Control agent on the primary database node. This will enable the discovery of all the other databases in the configuration as targets which will be ready to be monitored.