Online Access Free 1z0-076 Practice Test

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.creating a guaranteed restore point on the primary database
• C.switching the primary database to the logical standby role
• D.starting media recovery on all the Leading Group Standby databases
• E.building a LogMiner dictionary on the primary database instance
• F.converting the designated physical standby database into a logical standby database

Examine the Data Guard configuration:
DGMGRL> show configuration;
Configuration - Animals
Protection Mode: MaxAvailability
Databases:
dogs - Primary database
sheep - Snapshot standby database
cats - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
You receive an error while attempting to raise the protection mode to Maximum Protection:
DGMGRL> edit configuration set protection mode as maxprotection;
Error: ORA-16627: operation disallowed since no standby databases would remain to support protection mode Failed.
Which is the minimum statement, or sequence of statements you must execute to enable successful raising of the protection mode to Maximum Protection?

• A.DGMGRL> edit database sheep set property LogXptMode=sync;
• B.DGMGRL> edit database dogs set property LogxptMode=sync;
  DGMGRL> edit database sheep set property LogxptMode=sync;
• C.DGMGRL> edit database dogs set property LogXptMode=sync;
  DGMGRL> edit database sheep set property LogxptMode=sync;
  DGMGRL> edit database cats set property LogXptMode=sync;
• D.DGMGRL> edit database cats set property LogXptMode=sync;
• E.DGMGRL> edit database dogs set property LogxptMode=sync;
• F.DGMGRL> edit database dogs set property LogXptMode=sync;
  DGMGRL> edit database cats set property LogXptMode=sync;

Which TWO observations are true about the Far Sync instance?

• A.Applies redo received
• B.Receives redo synchronously from the primary database
• C.Includes a standby control file, password file, data files, standby redo logs, and archive logs
• D.Can be created using the RMAN DUPLICATE command
• E.Can only be created using a series of SQL commands

Which TWO statements are true about Real-Time Query?

• A.Setting standby_max_data_delay=0 requires synchronous redo transport.
• B.Real-Time Query has no limitations regarding the protection level of the Data Guard environment.
• C.Real-Time Query sessions can be connected to a Far Sync instance.
• D.A standby database enabled for Real-Time Query cannot be the Fast-Start Failover target of the Data Guard configuration.
• E.Disabling Real-Time Query prevents the automatic start of redo apply when a physical standby databases opened read only.

Which three are prerequisites for enabling Fast-Start Failover?

• A.The Data Guard environment must be managed by the Data Guard Broker.
• B.The configuration must be operating in either Maximum Performance or Maximum Protection mode.
• C.You can specify only one standby database as the fast-start failover target.
• D.Flashback Database must be enabled only on the Fast-Start Failover target standby database.
• E.The maximum protection mode can be used, but with two or more standby databases.
• F.Flashback Database must be enabled on both the primary database and the Fast-Start Failover target standby database.