Online Access Free 1z1-076 Practice Test

Your expertise is requested for these customer requirements:
The Data Guard environment must be in maximum protection mode.
Reports must be offloaded to a physical standby database.
There must be no lag between the primary and standby databases that affect the reports produced.
The primary database must be resilient in case of a single network failure.
Which solution is correct for these requirements?

• A.One physical standby database with Real-Time Query enabled and STANDBY_MAX_DATA_DELAY parameter set to zero, receiving redo from the primary with synchronous transport
• B.Two physical standby databases with Real-Time Query enabled, receiving redo from the primary with the LOG_ARCHIVE_DEST_n attributes SYNC NOAFFIRM to minimize the performance impact on the primary
• C.Two standby databases, at least one of them a physical standby with Real-Time Query enabled and the STANDBY_MAX_DATA_DELAY parameter set to zero, receiving redo from the primary with synchronous transport
• D.Two standby databases, at least one of them a physical standby with Real-Time Query enabled and the STANDBY_MAX_DATA_DELAY parameter set to zero, receiving redo from the primary with asynchronous transport
• E.One physical standby database with Real-Time Query enabled, receiving redo from two Far Sync instances that are connected to the primary

Which three actions are performed by the START PLAN procedure of the DBMS ROLLING package?

• A.creating a guaranteed restore point on the standby databases
• B.building a LogMiner dictionary on the primary database instance
• C.creating a guaranteed restore point on the primary database
• D.switching the primary database to the logical standby role
• E.starting media recovery on all the Leading Group Standby databases
• F.converting the designated physical standby database into a logical standby database

Which two are true concerning the configuring of Flashback database in a Data Guard environment?

• A.It is required in order for a snapshot standby database to be converted to a physical standby database.
• B.It permits a physical standby database to be converted to a snapshot standby database.
• C.It enables the use of far sync instances.
• D.It is a prerequisite for the use of Fast Start Failover.
• E.It permits a primary database that was disabled after failover to be reinstated as a standby.

Which three statements are true about Data Guard database modes and states?

• A.Databases in a Data Guard Configuration need not operate in Flashback Logging mode.
• B.A Logical Standby Database can be in MOUNT state while applying changes.
• C.Force Logging Mode is not required for a primary database but is recommended.
• D.The Primary Database can operate in noarchivelog mode.
• E.A primary database may ship redo directly to more than nine standby databases.

Suppose that you manage the following databases in your environment:
* boston: Primary database with a single PDB called DEVI
* london: Physical standby database protecting the PDB called DEVI
* orcl: Stand-alone database with a single PDB called PDB1 as a remote clone source You are planning to run the following command to create a remote clone in the primary database (boston) using pdbi in orcl:
Which are the THREE prerequisites for automating instantiation of the PDB in the standby database (london)?

• A.Set STANDBY_FILE_MANAGEMENT to auto in the london database.
• B.Enable Active Data Guard in the _ondon database.
• C.Set standby_pdb_source_file_dblink to clone_link in the london database.
• D.Set STANDBY_PDB_SOURCE_FILE_DIRECTORY to <location of the PDB> in the london database.
• E.Open PDBI (remote clone source) in Read Write.
• F.Open PDBI (remote clone source) in Read Only.