Online Access Free 1z0-076 Exam Questions

You must configure flashback database for your Oracle 19c databases that will be part of a Data Guard Broker configuration.
The databases are all in ARCHIVELOG mode.
You will execute the SQL statement:
ALTER DATABASE FLASHBACK ON;
Which three are true concerning this command?

• A.It will execute successfully on an Oracle 19c physical standby database while Real Time Query is active.
• B.If executed successfully on an Oracle 19c primary database, flashback will also be enabled on all logical standby databases that are part of the configuration.
• C.It will execute successfully while an Oracle 19c primary database is mounted.
• D.It will execute successfully on an Oracle 19c logical standby database while SQL apply is active.
• E.If executed successfully on an Oracle 19c primary database, flashback will also be enabled on all physical standby databases that are part of the configuration.
• F.It will execute successfully while an Oracle 19c primary database is open.

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.Enterprise Manager Cloud Control
• B.CRSCTL
• C.SQL*Plus
• D.GDCCTL
• E.RMAN
• F.SRVCTL
• G.DGMGRL

Your Data Guard environment consists of these components and settings:
A primary database supporting an OLTP workload
A remote physical standby database
Real-time query is enabled
The redo transport mode is set to SYNC
The protection mode is set to Maximum Availability
Which two statements are true regarding the DelayMins database property for the standby database?

• A.It allows user errors on the primary to be recovered by using the physical standby database.
• B.It specifies a delay before the primary ships redo to the standby destination having DelayMins set.
• C.It allows logical corruptions on the primary to be recovered by using the physical standby database.
• D.It can only be enabled for a configuration in Maximum Performance mode.
• E.It can only be enabled for a configuration in Maximum Availability mode.
• F.It enables you to bypass the default network timeout interval specified for the standby redo transport destination.

Which TWO statements are true regarding Data Guard Broker?

• A.It can be used to monitor redo transport and log apply services.
• 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 perform failovers and switchovers.
• D.It automatically starts the DMON process for the database instances that are part of a Data Guard configuration.
• E.It can be used to create and manage standby databases.

Which three are true regarding prerequisites for a logical standby database as a disaster recovery solution?

• A.Do not perform any nologging operations on the primary.
• B.Ensure that no BFILE LOB data types are contained in the primary database.
• C.Ensure that supplemental logging is enabled on the primary database.
• D.Ensure that no ROWID data types are contained in the primary database.
• E.Ensure that flashback is enabled on the primary database.