Which two are true about Data Guard Broker configuration parameter administration? (Choose two.)
A. Changes to database properties always result in immediate updates to initialization parameters in the SPFILE even when the configuration is disabled.
B. Changes to database properties that might result in changes to static initialization parameters may not be done using the Data Guard Broker.
C. Changes to database properties that might result in changes to dynamic initialization parameters may be done using the Data Guard Broker when the configuration is disabled.
D. An SPFILE must be used for all the databases in a configuration.
E. Changes to database initialization parameters cannot be done directly for properties that are controlled by the Data Guard Broker.
Which three are true regarding prerequisites for a logical standby database as a disaster recovery solution? (Choose three.)
A. Ensure that no ROWID data types are contained in the primary database.
B. Ensure that flashback is enabled on the primary database.
C. Ensure that supplemental logging is enabled on the primary database.
D. Do not perform any nologging operations on the primary.
E. Ensure that no BFILE LOB data types are contained in the primary database.
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.
Which two statements are true about block media recovery in a Data Guard environment? (Choose two.)
A. When using RMAN, the RECOVER CORRUPTION LIST command can automatically use blocks from flashback logs.
B. A corrupt block on the primary database can be recovered automatically, using blocks from a physical standby database that has the Real-Time Query enabled.
C. DB_LOST_WRITE_PROTECT must be set to TYPICAL to enable Automatic Block Media Recovery.
D. When using RMAN, the RECOVER CORRUPTION LIST command can use blocks from change tracking files.
E. DB_LOST_WRITE_PROTECT must be set to FULL to enable Automatic Block Media Recovery.
You must propose an Oracle Data Guard configuration for a database supporting a DSS workload that meets these permanent requirements:
1.
The performance impact on the primary database should be kept to a minimum.
2.
Creating and maintaining materialized views should not impact the performance of the primary database.
Additionally, there are these requirements, only the one of which is ever done at any one time:
3.
It should be possible to apply designated patches with a minimum amount of downtime.
4.
Upgrading to a new database release should be performed with the least possible amount of downtime.
5.
New application software releases should be tested against an exact up-to-date replica of the production database.
You propose a configuration operating in Maximum Performance mode with a primary database and one logical standby database.
Which requirements do you meet?
A. 1, 2, and 3
B. 2 and 5
C. 1 and 5
D. 1, 2, 3, 4, and 5
E. 1, 2, and 4
F. 2, 3, and 5
Examine the Data Guard configuration:
DGMGRL> show configuration;
Configuration ?Animals
Protection Mode: MaxAvailability
Databases: dogs - Primary database cats - Physical standby database sheep - Logical standby database
Fast-Start Failover: DISABLED
Configuration Status:
ORA-01034: ORACLE not available ORA-16625: cannot reach database "dogs" DGM-17017: unable to determine configuration status
Which three will be true after a successful failover to Sheep? (Choose three.)
A. Cats will be in the disabled state and must be manually reinstated.
B. Cats will be in the disabled state and must be manually re-created.
C. Dogs will be in the disabled state and must be manually re-created.
D. Dogs will be in the disabled state and must be manually reinstated.
E. The configuration will be in Maximum Performance mode.
F. The configuration will be in Maximum Availability mode.
The Oracle database 12c Observer is currently running on host1 and you wish to have it running on host2.
Examine this list of possible steps:
1) Stop the observer on host1.
2) Disable Fast-Start Failover.
3) Update the broker configuration with the new observer hostname.
4) Enable Fast-Start Failover.
5) Start the Observer on host2.
Which contains the minimum required steps to move the observer to host2?
A. Execute only task 5.
B. Execute tasks 1, 3, and 5.
C. Execute tasks 1, 2, 3, 4, and 5.
D. Execute tasks 1 and 5.
Which three are true about the rolling release upgrade method for Data Guard environments using a transient Logical Standby database? (Choose three.)
A. A rolling release upgrade can be performed with the Data Guard environment in any protection mode.
B. The transient logical standby database used for the rolling release upgrade can run with a newer version of the Oracle software than the primary database.
C. The transient logical standby database used for the rolling release upgrade must have the same DBID as the primary database.
D. The original primary database can ship redo to any standby database that is part of the Data Guard configuration during the rolling release upgrade process.
E. SELECT GUARD_STATUS FROM V$DATABASE; must return NONE as a prerequisite for the rolling release upgrade with a transient logical standby database.
Which three statements are true about Data Guard database modes and states? (Choose three.)
A. A primary database may ship redo directly to more than mine standby databases.
B. Force Logging Mode is not required for a primary database but is recommended.
C. A Logical Standby Database can be in MOUNT state while applying changes.
D. The Primary Database can operate in noarchivelog mode.
E. Databases in a Data Guard Configuration need not operate in Flashback Logging mode.
Examine the Data Guard configuration:
Properties:
FastStartFailoverThreshold = `30'
OperationTimeout = `30'
TraceLevel = `USER'
FastStartFailoverLagLimit = `30'
CommunicationTimeout = `180'
ObserverReconnect = `10'
FastStartFailoverAutReinstate = `TRUE'
FastStartFailoverPmyShutdown = `TRUE'
BystandersFollowRoleChange = `all'
ObserverOverride = `FALSE'
Fast-Start Failover: ENABLED
Threshold: 30 seconds
Target: dogs
Observer: prutser6.example.com
Lag Limit: 30 seconds (not in use)
Shutdown Primary: TRUE
Auto-reinstate: TRUE
Observer Reconnect: 10 seconds
Observer Override:
Configuration Status:
SUCCESS
What happens if you issue "failover to dogs;" at the DGMGRL prompt while connected to Dogs?
A. The failover succeeds, Sheep becomes the new target standby database, and Cats is automatically reinstated.
B. The failover succeeds and Cats is automatically reinstated.
C. The failover succeeds and Cats is left running.
D. The failover succeeds and Cats is terminated.
E. It results in an error indicating that a failover is not allowed.
Nowadays, the certification exams become more and more important and required by more and more enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare for the exam in a short time with less efforts? How to get a ideal result and how to find the most reliable resources? Here on Vcedump.com, you will find all the answers. Vcedump.com provide not only Oracle exam questions, answers and explanations but also complete assistance on your exam preparation and certification application. If you are confused on your 1Z0-066 exam preparations and Oracle certification application, do not hesitate to visit our Vcedump.com to find your solutions here.