Valid 1Z0-066 Dumps For Oracle Exam

Question No. 1

Examine the Data Guard configuration after an accidental switchover to Sheep:

DGMGRL> show configuration;

Configuration Animals

Protection Mode: MaxAvailability

Databases:

sheep Primary database

dogs Logical standby database

cats Physical standby database (disabled)

ORA-16795: the standby database needs to be re-created

Fast-Start Failover: DISABLED

Configuration Status:

SUCCESS

Which three will be true after a switchover to Dogs? (Choose three.)

• A. Sheep will be a disabled logical standby database.
• B. Sheep will be an enabled logical standby database.
• C. Cats will be a disabled physical standby database that can be manually enabled.
• D. Cats will be an enabled physical standby database.
• E. Dogs will be the primary database.

Question No. 2

Examine the Fast-start configuration:

DGMGRL> show fast_start failover;

Fast-Start Failover: ENABLED

Threshold : 30 seconds

Target: sheep

Observer : ol7.example.com

Lag Limit: 30 seconds (not in use)

Shutdown Primary: TRUE

Auto-reinstate: TRUE

Observer Reconnect: (none)

Observer Override: FALSE

Configurable Failover Conditions

Health Conditions:

Corrupted Controlfile YES

Corrupted Dictionary YES

Inaccessible Logfile NO

Stuck Archiver YES

Datafile Offline YES

Oracle Error Conditions:

(none)

Which three are true? (Choose three.)

• A. The observer will initiate a failover when the primary database is unable to produce local archived redo log files.
• B. An automatic failover will be initiated even if the target standby database lags behind the primary.
• C. The observer is running.
• D. A failover may occur if the observer has lost connectivity to the primary database, even if the Fast-Start Failover target standby database has a good connection to the primary database.
• E. The configuration operates in Maximum Availability mode.
• F. The configuration operates in Maximum Performance mode.

Question No. 3

You edit the DGConnectIdentifier database property using the edit database set property DGMGRL command.

Which two are effects of this change? (Choose two.)

• A. The fal_client database initialization parameter on all standby databases is updated with the new value.
• B. The service attribute of the log_archive_dest_n initialization parameter for any database referring to the specified database is updated with the new value.
• C. The fal_client database initialization parameter for the specified database is updated with the new value.
• D. The broker configuration must be disabled and then enabled to use the new connection property.
• E. The service attribute of the log_archive_dest_n initialization parameter referring to all standby databases is updated with the new value.

Question No. 4

Examine this command executed on a physical standby database to transition it to a logical standby database:

SQL> ALTER DATABASE RECOVER TO LOGICAL STANDBY prodlgsby;

Which statement is true regarding the execution of this command?

• A. FLASHBACK is automatically enabled when transitioning to the logical standby database.
• B. The Managed Recovery Process (MRPO) continues applying redo up to the SCN immediately preceding the redo corresponding to the LogMiner dictionary build.
• C. Supplemental logging will be enabled on the logical standby database when the physical database is transitioned to the logical standby database.
• D. SQL apply is automatically started when transitioning to the logical standby database.
• E. It will automatically start redo apply.

Question No. 5

You are monitoring your Data Guard broker configuration and issue this set of DGMGRL commands:

DGMGRL> SHOW CONFIGURATION

Configuration DRSolution

Protection Mode: MaxPerformance

Databases:

Close_by Primary database

FS_inst Far Sync

Far_away Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:

SUCCESS

What is true concerning this configuration?

• A. The Close_by primary database instance forwards redo to the FS_inst Far Sync instance, which forwards the redo in turn to the Far_away physical standby database instance.
• B. The far sync instance will not forward redo to the Far_away physical standby because the Protection mode is not MaxProtection.
• C. The close_by primary database forwards redo to the Far_away physical standby directly and also sends redo to the FS_inst Far Sync instance.
• D. The far sync instance will not forward redo to the Far_away physical standby because Fast-Start Failover is disabled.
• E. The FS_inst Far Sync instance forwards redo to the Far_away physical standby only if the close_by primary database is not able to do so.

Question No. 6

Which three are true concerning Automatic Block Media Recovery in a Data Guard environment when running an application as an ordinary Oracle user? (Choose three.)

• A. Real Time Query must be enabled on the primary database.
• B. Real Time Query must be enabled on the physical standby database.
• C. If a physically corrupt block is discovered on a physical standby database, then a valid block image from the primary database is retrieved.
• D. If a physically corrupt block is discovered on the primary database, then a valid block image from a physical standby database is retrieved.
• E. If a physically corrupt block is discovered on a logical standby database, then a valid block image from the primary database is retrieved.
• F. If a physically corrupt block is discovered on a primary database, then a valid block image from the logically standby database is retrieved.