NEW QUESTION 1
Which two statements are true regarding Data Guard Broker?

• A. It automatically adds the primary database to an existing broker configuration when Enterprise Manager Cloud Control is used to create a standby
• B. It automatically starts the DMON process for the database instances that are part of a Data Guard configuration.
• C. it can be used to perform failovers and switchovers.
• D. It can be used to create and manage standby databases.
• E. It can be used to monitor redo transport and log apply services.

Answer: BC

NEW QUESTION 2
Which three are true concerning database states after a successful switchover?

• A. If the former primary database became a logical standby database it will be in mount state
• B. The new primary database will be open read-write.
• C. The former primary database will always be open.
• D. If the former primary database became a logical standby database it will be open read- write.
• E. if the former primary database became a physical standby database it will always be open read-only.
• F. If the former primary database became a physical standby database it will be in the same state as the former physical standby database

Answer: ABE

NEW QUESTION 3
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 4
Examine the Data Guard configuration:

Which three will be true after a switchover to Sheep?

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

Answer: ABE

NEW QUESTION 5
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 6
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 7
Which two are true about the creation of a Data Guard Broker configuration?

• A. in a broker configuration, the primary database name must match the DB_UNIQUE_NAME value in the database initialization parameter file.
• B. A primary database profile may be added to the configuration prior to creating the primary database.
• C. A standby database profile may be added to the configuration prior to creating that standby database.
• D. A newly created broker configuration requires at least one standby database profile to be specified at the time the configuration is created.
• E. A newly created broker configuration is in the disabled state

Answer: DE

NEW QUESTION 8
You created a physical standby database PRODSBY1 from the primary database PROD using SQL and RMAN Which two are prerequisites for creating a Data Guard Broker configuration to manage these databases?

• A. The standby database must have supplemental logging enabled.
• B. The primary database must have FORCE LOGGING enabled
• C. The DG_BROKER_START parameter must be set to TRUE for both database instances.
• D. The primary database must have supplemental logging enabled.
• E. A local net service name to enable connectivity to the PRODSBY1 database instance must be defined on the primary database host.

Answer: BC

NEW QUESTION 9
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 10
Which four factors can influence the rate of SQL apply on a logical standby database?

• A. the size of the undo tablespace on the logical standby database
• B. the number of full table scans performed by SQL apply
• C. the number of coordinator processes on the standby database instance
• D. the size of the shared pool
• E. the number of APPLIER processes
• F. the number of PREPARER processes

Answer: BDEF

NEW QUESTION 11
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 12
Which two are true about rolling release upgrades in a Data Guard environment?

• A. The background process DMON must be enabled on the primary and standby databases during a rolling release upgrade procedure
• B. A physical standby database can be converted to a logical standby database temporarily.
• C. Rolling release upgrades require the background process RVWR to write flashback logs on the standby database.
• D. The KEEP IDENTITY clause ensures that a logical standby database keeps the same DBID as the primary database.
• E. The recovery point objective increases proportionally to the duration of the rolling release upgrade procedure.

Answer: BD

NEW QUESTION 13
Which two are true about database roles in an Oracle Data Guard Configuration?

• A. a configuration consisting only of a primary and one or more physical standby databases can support a rolling release upgrade.
• B. A Logical Standby Database can be converted to a Snapshot Standby Database.
• C. A Logical Standby Database can cascade redo to a terminal destination
• D. A Snapshot Standby Database can be a fast-start failover target
• E. A Physical Standby Database can be converted into a Logical Standby Database.

Answer: BE

NEW QUESTION 14
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 15
Examine the Fast-start configuration

Oracle Error Conditions: (none) Which three are true?

• 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

Answer: ACE

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

• A. Different pluggable databases within a logical standby database may have different guard statuses.
• B. The Data Guard broker automatically always opens the pluggable databases of a standby database after a role change operation.
• C. The Data Guard broker automatically opens all pluggable databases of a primary database a role change operation.
• D. The CDBDBA privilege must be used instead of the SYSDBA privilege for connections as SYS to the root container of a multi-tenant standbydatabase.
• E. A multi-tenant standby database can have fewer pluggable databases than the primary container database

Answer: CD

NEW QUESTION 17
Which three are true about using RMAN in a Data Guard environment?

• A. A recovery catalog is required when RMAN is used to take backups from a logical standby database in a Data Guard configuration if you plan to recover the primary using those backups.
• B. Backups of archived redo logs taken on a physical standby are interchangeable with a primary.
• C. A recovery catalog is required when RMAN is used to take backups from a physical standby database if you plan to recover the primary using those backups
• D. Backups of control files taken on a physical standby are not interchangeable with a primary.
• E. Backups of data files taken on a physical standby are interchangeable with a primary.

Answer: BCE

NEW QUESTION 18
Which two are true about offloading backups to a physical standby database in a Data Guard environment?

• A. The standby database must be registered in an RMAN catalog after the primary database has been registered
• B. The standby database cannot be registered in an RMAN catalog if the primary database has not been registered
• C. Backups of the standby control file taken while connected to the catalog where the database is registered, may be used to restore the control file onthe primary database.
• D. The standby database must be registered in an RMAN catalog before the primary database has been registered

Answer: BC

NEW QUESTION 19
......