Free Oracle 1z1-076 Exam Dumps Questions & Answers

You created two remote physical standby databases using SQL and RMAN.
The primary database is a four-instance RAC database and each physical standby database has two instances.
Roles-based services are used for client connectivity and have been defined in the Grid Infrastructure.
Consider these operational requirements:
* The ability to manage multiple standby databases with a single tool
* The simplification of switchovers, failovers, reinstatements, and conversions to and from snapshot standby databases
* The automation of failovers to a specified target standby database
Which TWO tools can be used to fulfill these requirements7

• A.SQL*Plus
• B.RMAN
• C.SRVCTL
• D.Enterprise Manager Cloud Control
• E.DGMGRL
• F.CRSCTL
• G.GDCCTL

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 set a critical threshold on the redo generation rate metric for a primary database.
• C.You can monitor the redo apply rate on a logical standby database.
• D.You can monitor the redo apply rate on a snapshot standby database.
• E.You can check if redo apply needs to be tuned.
• F.You can check the potential data loss in the event of a disaster.

Which three are true about using RMAN in a Data Guard environment?

• A.Backups of control files taken on a physical standby are not interchangeable with a primary.
• B.Backups of data files taken on a physical standby are interchangeable with a primary.
• C.A recovery catalog is required when RMAN is used to take backups from a logical standby database in a Data Guard configuration if you plan to recover the primary using those backups.
• D.Backups of archived redo logs taken on a physical standby are interchangeable with a primary.
• E.A recovery catalog is required when RMAN is used to take backups from a physical standby database if you plan to recover the primary using those backups.

You are using Data Guard in conjunction with Global Database Services.
You have a Data Guard Broker configuration called Sales and a GDS pool called Prod.
Which three are true concerning the management of the broker configuration when using GDS?

• 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.DGMGRL may be used to add a single database to the Sales configuration even if Sales is a member of the Prod pool.
• D.Adding a database to the Sales configuration with DGMGRL automatically adds the database to the Prod Pool.
• E.Performing a role change with DGMGRL automatically notifies GDS which in turn activates the appropriate services.

Which TWO statements are true regarding Data Guard Broker?

• A.It can be used to create and manage standby databases.
• B.It automatically starts the DMON process for the database instances that are part of a Data Guard configuration.
• C.It can be used to monitor redo transport and log apply services.
• D.It can be used to perform failovers and switchovers.
• E.It automatically adds the primary database to an existing broker configuration when Enterprise Manager Cloud Control is used to create a standby.