A Review Of Certified 1z0-066 Study Guides

NEW QUESTION 1
Examine the Data Guard configuration:

Identify two possible reasons for this error.

• A. The FastStartFailoverTarget property is not set on Sheep.
• B. The FastStartFailoverTarget property is not set on Dogs.
• C. The FastStartFailoverTarget property is not set on DogsFSI.
• D. The LogXptMode property is set to ASYNC on Dogs.
• E. The RedoRoutes property is not set on Dogs
• F. The RedoRoutes property is not set on DogsFSI

Answer: AD

NEW QUESTION 2
Which two are true about the use of RMAN recovery catalogs when offloading backups to a physical standby database?

• A. It backups that are offloaded to a physical standby database are taken when not connected to a recovery catalog, then they may still be used for restoration on the primary database.
• B. The physical standby database may be used to register the database in the recovery catalog, if the primary is not registered.
• C. The primary and physical standby databases must be registered separately in the recovery catalog, if a far sync instance is used to route redo to the physical standby database.
• D. It is not necessary to use a recovery catalog unless a far sync instance is used to route redo to the physical standby database.
• E. Primary and physical standby database may use different virtual recovery catalogs in the same physical recovery catalog

Answer: DE

NEW QUESTION 3
Examine the Data Guard configuration: DGMGRL> show configuration;
Configuration -Animals Protection Mode MaxAvailability Databases
dogs- Primary database
cats- Snapshot standby database sheep- Snapshot standby database Fast-Start Failover DISABLED
Configuration Status: ORA-01034: ORACLE not available ORA-16625: cannot reach database "dogs'1 DGM-17017 unable to determine configuration status
You wish to perform a failover to Sheep
Which command, or sequence of commands, should you issue to the broker before executing "failover to sheep", using the broker?

• A. DGMGRL> convert database cats to physical standby,
• B. DGMGRL> convert database sheep to physical standby;
• C. DGMGRL> convert database sheep to physical standby; DGMGRL> convert database cats to physical standby;
• D. DGMGRL>edit configuration set protection mode as maxperformance; DGMGRL> convert database sheep to physical standby;
• E. None, because you can directly failover to a Snapshot Standby Database

Answer: C

NEW QUESTION 4
You must configure an Oracle Data Guard environment consisting of:
1. A primary database
2 One Physical Standby Database
3. One Logical Standby Database You must meet these requirements:
1. Primary database availability should not be compromised by the availability of the standby databases.
2. Under normal operations, transactions executed on the primary database should not commit before redo is written to disk on both the primary database and at least one standby database.
Which redo transport mode and which protection mode would you configure to meet these requirements?

• A. SYNC AFFIRM and Maximum Protection
• B. SYNC NOAFFIRM and Maximum Protection
• C. SYNC AFFIRM and Maximum Availability
• D. SYNC NOAFFIRM and Maximum Availability
• E. ASYNC and Maximum Performance

Answer: C

NEW QUESTION 5
Attempting to start the observer raises an error DGMGRL> start observer:
DGM-16954 Unable to open and lock the Observer configuration file Failed.
Identify two possible ways to start the observer successfully

• A. Set the Observer Override property to TRUE before starting the observer
• B. Create a broker configuration and enable Fast-Start Failover before starting theobserver
• C. Start the observer using a different observer configuration file.
• D. start the observer in a different working directory.
• E. Enable Fast-Start Failover before starting the observer

Answer: CD

NEW QUESTION 6
Examine the Data Guard configuration:

Which three will be true after a successful failover to Cats?

• A. Sheep will be in the disabled state.
• B. Sheep will be in the enabled state.
• C. Dogs will be in the disabled state and has to be manually reinstated
• D. The configuration will be in Maximum Performance mode.
• E. The configuration will be in Maximum Availability mode.

Answer: BCD

NEW QUESTION 7
Examine the Data Guard configuration:


Configuration Status: SUCCESS Which two are true?

• A. The observer must run on host ol5.example com and is currently not running.
• B. The observer will reinstate Sheep automatically after a failover, if required.
• C. The observer will mark another standby database as the failover target if the original failover target becomes unavailable.
• D. The observer will detect if the primary database is unable to accept new connections
• E. The former primary database will not be reinstated automatically alter a failover.

Answer: BE

NEW QUESTION 8
Examine the Data Guard configuration:

Which three will be true after a switchover to Sheep?

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

Answer: ACE

NEW QUESTION 9
Which four requirements can be met by deploying a logical standby database?

• A. Support for workloads requiring additional indexes.
• B. it can be used to create additional schemas.
• C. it can be used to create additional tables.
• D. It must have the same physical structure as the primary database.
• E. it must provide a disaster-recovery solution that protects all data with capability of performing switchovers and failovers.
• F. Support for workloads requiring additional materialized views.
• G. it can be used for Real Application Testing without affecting the disaster recovery capabilities.

Answer: ACEG

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

Which three will be true after a switchover to Dogs?

• 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.

Answer: BCE

NEW QUESTION 11
Which three are required in order to use Real-Time Query without lagging behind the primary?

• A. There must be standby redo logs on the standby database
• B. There must be standby redo logs on the primary database.
• C. The primary must ship redo asynchronously.
• D. COMPATIBLE must be set to 11.1.0 or higher.
• E. Real-Time apply must be enabled on the standby.

Answer: ADE

NEW QUESTION 12
Which three statements are true about snapshot standby databases?

• A. Tablespaces can be dropped.
• B. Tables can be dropped
• C. The broker may be used to fail over to a snapshot standby database.
• D. A logical standby database can be converted into a snapshot standby database.
• E. Tablespaces can be created.

Answer: ABE

NEW QUESTION 13
You edit the DGConnectldentifier database property using the edit database set property DGMGRL command Which two are effects of this change?

• 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

Answer: AB

NEW QUESTION 14
Examine this list of possible steps:
1 Raise the compatibility level on both databases
2.Restart SQL Apply on the upgraded logical standby database 3 Start SQL Apply on the old primary database.
4. Perform a Switchover to the logical standby database
5. Upgrade the logical standby database.
6. Upgrade the old primary database.
Which is the minimum number of steps in the correct order, to perform a rolling release upgrade of a data guard environment using an existing logical standby database and to enable the new functionality?

• A. 5,2.4,3,6,1
• B. 1,5,2,4,6,3
• C. 5,2,4,6,3,1
• D. 4,6,5,2,3,1
• E. 5,2,4,1

Answer: A

NEW QUESTION 15
Which three statements are true about Data Guard configurations?

• A. All databases in one Data Guard environment must have the same database name.
• B. VALID_FOR is a LOG_ARCHIVE_DEST_N attribute that enables DB role change operations without having to modify LOG_ARCHIVE_DEST_nwhen performing switchovers or failovers.
• C. For Standard Edition, LOG_ARCHIVE_DUPLEX_DEST is used to configure redo transport, from the primary to the standby database.
• D. When using the Data Guard Broker, an spfile is not required.
• E. Up to 30 physical standby databases may exist within one configuration.
• F. The Oracle recommendation for the number of standby redo log groups per thread is one more than the number of online redo log groups per thread

Answer: AEF

NEW QUESTION 16
After converting your physical standby database to a logical database, you get an error:

How can you rectify the error?

• A. Add a logical standby database PRODSBY and enable it, thereby replacing the physical standby database metadata in the broker configuration.
• B. Remove the physical standby database PRODSBY from the broker configuration, add a logical standby database PRODSBY to the broker configuration and enable it.
• C. Reinstate the physical standby database PRODSBY as a logical standby, thereby replacing the physical standby database metadata in the broker configuration.
• D. Reinstate both the primary and physical standby databases The broker will automatically detect that PRODSBY is a logical standby update to the metadata.

Answer: D

NEW QUESTION 17
A query on the view DBA_LOGSTBY_UNSUPPORTED on your primary database returns no rows
As a result of this, you decide that an upgrade may use logical standby databases. Which two are true about upgrading Data Guard environments consisting of one logical
standby database running on a separate host from the primary?

• A. The upgrade always requires downtown until the upgrade of the logical standby is completed
• B. Using manual upgrade, catctl.pl can be executed in some cases on the primary and standby database simultaneously.
• C. The upgrade always required downtime until the upgrade of the primary is completed
• D. Using manual upgrade, catupgr.sql needs to run on the primary database only.
• E. SQL Apply on the local standby database must be stopped while the primary database is upgraded.
• F. Fast-Start Failover can be used to protect the primary database during the upgrade.

Answer: BE

NEW QUESTION 18
You must manually reinstate a database using DGMGRL
To which database should you connect with DGMGRL before issuing the REINSTATE command and in which state should the target database be?

• A. The target database should be in NOMOUNT state and DGMGRL should be connected to any database that is a member of the configuration
• B. The target database should be MOUNTED and DGMGRL should be connected to any database that is a member of the configuration
• C. The target database should be MOUNTED and DGMGRL should be connected to the primary database.
• D. The target database should be MOUNTED and DGMGRL should be connected to the target database
• E. The target database should be in NOMOUNT state and DGMGRL should be connected to the primary database

Answer: C

NEW QUESTION 19
There are currently 6 APPLIER and 6 PREPARER processes running and no idle APPLIER processes on your logical standby database. The MAX_SERVERS SQL apply parameter and number of archiver processes are both set to 12. Identify two changes, each of which would allow you to increase the number of APPLIER processes.

• A. Increase the PROCESSES initialization parameter
• B. Increase the value for the MAX_SERVERS SQL apply parameter.
• C. Decrease the number of archiver processes on the standby databas
• D. increase the PARALLEL_MAX_SERVER initialization parameter
• E. Decrease the number of PREPARER processes
• F. Increase the RECOVERY_PARALLEUSM initialization parameter

Answer: BE

NEW QUESTION 20
In which two cases is it possible to change the protection mode to maximum protection using Enterprise Manager Cloud Control?

• A. a snapshot standby database is the only standby database in the Data Guard configuration.
• B. A logical standby database is the only standby database in the data guard configuration.
• C. A far sync instance is the only Data Guard configuration member receiving redo in synchronous mode.
• D. Flashback is not enabled for either the primary database, the standby database, or both in the Data Guard configuration.
• E. The primary and standby databases are hosted on different operating systems.

Answer: BE

NEW QUESTION 21
A customer has these requirements for their potential Data Guard implementation:
1. Zero data loss must still be guaranteed through the loss of any one configuration component.
2 The primary database must be protected against a regional disaster
3. Performance overheads on the primary should be minimized as much as possible given these requirements.
4. Downtime on the primary database for any reason must be kept to a minimum. Components referred to in the broker commands are:

Which Data Guard broker commands are needed to implement these requirements?

• A. EDIT DATABASE prima SET PROPERY REDOROUTES=' (LOCAL: physt1, FASTSYNC)'; EDIT DATABASE prima SET PROPERY REDOROUTES=' (LOCAL: fs1 SYNC)'; EDIT FAR_SYNC fs1 SET PROPERTY REDORUOTES=' (pnma: physt2 SYNC)'; EDIT CONFIGURATION SET PROTECTION MODE AS MAXAVAILABILITY
• B. EDIT DATABASE prima SET PROPERY REDOROUTES=' (LOCAL: fs1 ASYNC)'; EDIT FAR_SYNC fs1 SET PROPERTY REDORUOTES=' (prima physt FASTSYNC)'; EDIT CONFIGURATION SET PROTECTION MODE AS MAXPROTECTION
• C. EDIT DATABASE prima SET PROPERY REDOROUTES^' (LOCAL: fs1 SYNC)'; EDIT FAR_SYNCfs1 SET PROPERTY REDORUOTES=' (prima physt ASYNC)'; EDITCONFIGURATION SET PROTECTION MODE AS MAXAVAILABILITY;
• D. EDIT DATABASE prima SET PROPERY REDOROUTES=' (LOCAL: physt1, FASTSYNC)'; EDIT DATABASE prima SET PROPERY REDOROUTES= (LOCAL: fs1. FASTSYNC)'; EDIT FAR_SYNC fs1 SET PROPERTY REDORUOTES=' (prima: physt2 ASYNC)'; EDIT CONFIGURATION SET PROTECTION MODE AS MAXAVAILABILITY;

Answer: A

NEW QUESTION 22
......