NEW QUESTION 1
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 2
You administer a Data Guard environment with a primary and two physical standby databases.
One of the physical standby databases is used for reporting and is on the same host as the primary database.
The other physical standby database is remote, used for disaster recovery and REDO is routed to it via a far sync instance.
Backups are offloaded to the remote physical standby.
Which three are true concerning the management of archive logs in this Data Guard configuration?

• A. Archive logs on the primary database may be deleted once they are applied on all standby databases.


• B. Archive logs on the primary database may be deleted once they are shipped on all standby databases.


• C. The deletion policy for archive logs on the remote physical standby should be set so that archived logs are deleted once they backed up at least once on the remote physical standby database.


• D. The deletion policy for archive logs on the remote physical standby should be set so that archived logs are deleted once they are applied on all standby databases.


• E. Archive logs on the primary database may be deleted once they are archived locally to disk.

Answer: ADE

NEW QUESTION 3
Which statement is true regarding Oracle Net connectivity for a Data Guard Broker configuration?

• A. To start SQL apply on a logical standby database, a TNS entry enabling connectivity to the primary database instance must be defined on the logical standby database host.


• B. the LOCALJJSTERNER initialization parameter must be set to the listener used to register the primary database instance.


• C. To enable Reatime Query on a physical standby database, a TNS entry enabling connectivity to the standby database instance must be defined on the primary database host.


• D. A TNS enabling connectivity to the primary database instance must be defined on each of the standby database hosts.


• E. A TNS entry or entries enabling connectivity to standby database instance(s) must bedefined on the primary database host.

Answer: D

NEW QUESTION 4
Which three are among the various tasks performed by the data Guard Monitor (DMON) process?

• A. performing role transitions when switchover requests are made


• B. communicating with DMON processes in other database instances that are part of the broker configuration


• C. activating role-based services appropriately in the various database instances of the configuration, based on the database role


• D. communicating with the DMON process of the observer to monitor a primary database in case a fast start failover is required.


• E. maintaining information about all members of the broker configuration in binary configuration files

Answer: ABE

NEW QUESTION 5
Which two Data Guard monitoring activities may be performed using Enterprise Manager Cloud Control?

• A. monitoring the redo apply rate on a physical standby


• B. monitoring the redo apply rate on a logical standby


• C. monitoring the undo generation rate on a logical standby


• D. monitoring the redo apply rate on a snapshot standby


• E. monitoring the transport lag


• F. monitoring the undo generation rate on the primary

Answer: AE

NEW QUESTION 6
Examine the Data Guard configuration:

Which three will be true after a switchover to Dogs?

• A. Sheep will be an enabled logical standby database.


• B. Cats will be an enabled physical standby database


• C. Dogs will be the primary database


• D. Sheep will be a disabled logical standby database


• E. Cats will be a disabled physical standby database

Answer: BCE

NEW QUESTION 7
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 8
Your Data Guard environment consists of these components and settings:
1. A primary database
2. Two remote physical standby databases
3. The redo transport mode is set to SYNC.
4. Real-time query is enabled for both standby databases.
5. The DB_BLOCK_CHECKING parameter is set to TRUE on both standby databases.
You notice an increase in redo apply lag time on both standby databases.
Which two would you recommend to reduce the redo apply lag on the standby databases?

• A. Increase the size of the buffer cache on the physical standby database instances.


• B. Increase the number of standby redo log files on the standby databases.


• C. Decrease the redo log file size on the primary database.


• D. Lower DB_BLOCK_CHECKING to MEDIUM or LOW on the standby databases.


• E. Increase the size of standby redo log files on the standby databases.

Answer: AD

NEW QUESTION 9
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 10
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 11
Which two are prerequisites for enabling Automatic Block Media Recovery in a Data Guard environment consisting of a primary database, one physical standby database and one logical standby database?

• A. FLASHBACK DATABASE must be enabled on the physical standby database.


• B. There must be connectivity between the primary and the physical standby database.


• C. FLASHBACK DATABASE must be enabled on the primary database.


• D. The physical standby database must have Real-Time Apply enabled.


• E. The logical standby database must have Real-Time Query enabled

Answer: CD

NEW QUESTION 12
Which two statements are true for Data Guard environments with multi-tenant databases?

• A. DB_UNIQUE_NAME must be specified differently for each pluggable database within a multi-tenant standby database.


• B. Each pluggable database within a multi-tenant physical standby database has a minimum of one associated Oracle Net service name.


• C. Each pluggable database within a multi-tenant physical standby has one MRP background process running during redo apply.


• D. A pluggable database within a multi-tenant standby database can have a different open mode than the container database


• E. A pluggable database within a multi-tenant standby database can have a different database role than the container database.

Answer: AD

NEW QUESTION 13
Which two Data Guard features require the use of flashback database by the broker?

• A. Read-Mostly physical standby implementations


• B. Far Sync Instances


• C. Fast-Start Failover


• D. Real Time Query


• E. Snapshot Standby databases

Answer: CE

NEW QUESTION 14
Which three are true concerning Automatic Block Media Recovery in a Data Guard environment when running an application as an ordinary Oracle user?

• A. Real Time Query must be enabled on the primary database


• B. Real Time Query must be enabled on the physical standby database.


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

Answer: BCD

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

• A. The upgrade requires downtime until the upgrade of the standby is completed.


• B. The broker must be disabled during the upgrade


• C. With manual upgrade, catupgrd.sql can be executed on the primary and standby databases simultaneously.


• D. The upgrade requires downtime until the upgrade of the primary is completed.


• E. The new release of the Oracle Software must be installed on both the primary and standby database hosts


• F. Redo Apply on the standby database must be stopped while the primary database is upgraded.


• G. Fast-Start Failover can be used to protect the primary database during the upgrade.

Answer: BDE

NEW QUESTION 16
Examine this query and its output:

Which are true?

• A. The observer is not connected to the database on which the query was executed.


• B. Cats is a bystander database.


• C. The observer is connected to the database on which the query was executed.


• D. The observer is currently running on o17.example com


• E. The observer is not running, but should run on o17 example.com.

Answer: A

NEW QUESTION 17
Which two are true about management of a far sync instance when using the Data Guard Broker?

• A. A far sync instance is in a disabled state in the broker configuration immediately after adding it


• B. A far sync instance that has its RedoRoutes property set may not be disabled in the broker configuration.


• C. Broker management of a far sync instance may only be disabled with the disable configuration DGMGRL command.


• D. A far sync instance need not exist before adding it to the broker configuration but may not be enabled until created

Answer: AB

NEW QUESTION 18
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 19
Which two are prerequisites for creating a standby database using Enterprise Manager cloud control?

• A. The primary database must have FORCE LOGGING enabled.


• B. The primary database must be in archive log mode


• C. A backup of the primary database must exist.


• D. The primary host and the proposed standby database host must run the same operating system.


• E. The primary database instance must be started using an SPFILE.


• F. The primary database must have flashback enabled

Answer: AB

NEW QUESTION 20
Which three statements are true about standby redo logs in a Data Guard configuration with no Oracle Streams or Goldengate configured?

• A. They are required on a logical standby for real-time apply


• B. They are required only for synchronous redo transport.


• C. Only standby databases can write redo to them.


• D. It is recommended to have them on the primary database.


• E. They are required on a physical standby for real-time apply.


• F. The LGWR process writes to them on a standby database.

Answer: ACE

NEW QUESTION 21
......