NEW QUESTION 1
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 2
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 3
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 4
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 5
You must use a physical standby database file to recover a data file on a primary database in a Data Guard environment.
Which three of these steps must be performed on the primary database after the file has been backed up using RMAN on the physical standby database?

• A. Connect to the primary database as the AUXILIARY.
• B. Catalog the data file copy for RMAN to use on the primary database for restore.
• C. Back up the data file as copy on the standby host to a location on the standby host.
• D. Switch to the data file copy using the RMAN SWITCH command.
• E. Back up the data file as copy on the standby host to a location on the primary host
• F. Connect to the primary database as the TARGET.

Answer: ABD

NEW QUESTION 6
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 7
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 8
Which three factors can influence the rate of redo apply on a physical standby database?

• A. the network latency between the primary and standby databases
• B. the number of archiver processes on the standby database
• C. the number and size of standby redo logs on the primary database
• D. the rate of redo generation on the primary database
• E. the number and size of standby redo logs on the standby database

Answer: ABE

NEW QUESTION 9
Which three are prerequisites for enabling Fast-Start Failover?

• A. The Fast-Start Failover target standby database must receive REDO directly from the primary database
• B. Flashback Database must be enabled on both the primary database and the Fast-Start Failover target standby database.
• C. Flashback Database must be enabled only on the Fast-Start Failover target standby database.
• D. The configuration must be operating in either Maximum Performance or Maximum Availability mode
• E. The configuration must be operating in either Maximum Performance or Maximum Protection mode
• F. The Data Guard environment must be managed by the Data Guard Broker.

Answer: BDF

NEW QUESTION 10
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 11
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 reasons for this error

• A. Fast-Start Failover is not yet enabled for this Data Guard configuration
• B. The observer configuration file is marked read-only.
• C. There is already an observer running for this Data Guard configuration.
• D. There is another observer running for a Data Guard configuration which uses the same observer configuration file
• E. The broker configuration has not yet been created.

Answer: BD

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

• A. Snapshot standby databases may be used for rolling release upgrades.
• B. if datafiles grow while a database is a snapshot standby database, then they shrink when converted back to a physical standby database.
• C. Flashback logs are used to convert a snapshot standby database back into a physical standby database.
• D. a snapshot standby database can have Real-Time Query enabled
• E. A guaranteed restore point is created automatically when a physical standby database is converted into a snapshot standby database.

Answer: CE

NEW QUESTION 13
A customer asks you to propose the most appropriate solution for this set of requirements:
1. We need a disaster recovery solution that enables us to fail over from our production database with zero data loss.
2. We want to generate reports from the proposed standby database at the same time that it is used for other purposes.
3. Developers may need to test occasionally on a copy of the live database.
You have to already confirmed that there are no unsupported data types on the primary database Which two solutions would you recommend?

• A. a remote physical standby database with RedoRoutesvia a far sync instance
• B. a snapshot standby database with synchronous redo transport
• C. a physical standby database with real-time query enabled
• D. a logical standby database
• E. a read mostly implementation of a physical standby database

Answer: BC

NEW QUESTION 14
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)'; EDIT CONFIGURATION 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 15
On your logical standby database, you specified these rules:

Which is true regarding the execution of the UNSKIP procedure?

• A. it succeeds only if SQL apply is stopped before deleting the SQL Apply filter
• B. it succeeds but the SQL Apply fitters are not deleted.
• C. It deletes both the SQL Apply filters.
• D. it returns an error because the syntax to delete a SQL Apply filter must specify the same object names as specified when the filter was added
• E. it succeeds only if all DML statements executed on the primary have been applied on the logical standby

Answer: D

NEW QUESTION 16
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 17
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 18
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