NEW QUESTION 1
You must configure an Oracle Data Guard environment consisting of:
1. A primary database
2. A Physical Standby Database
3. A Snapshot 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 the primary database and on at least one standby database.
Which redo transport mode, and which protection mode should 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 2
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 3
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 4
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 5
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 6
You must propose an Oracle Data Guard configuration tor a database supporting an OLTP workload that meets these permanent requirements:
1. Data loss is not permitted.
2. Read-only applications should not connect to the primary database instance. Additionally, there are these requirements, only one of which is ever done at any one time:
3. It should be possible to apply and test 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 primary database with one physical standby database configured in Maximum Protection mode.
Which requirements do you meet?

• A. 2,3, 4, and 5
• B. 1,2, 3,4, and 5
• C. 1 and 2
• D. only requirement 5
• E. only requirement 1

Answer: C

NEW QUESTION 7
Which three are true concerning restoring of RMAN backups to primary and physical standby databases in a Data Guard environment?

• A. Backups of data files taken on the primary database may be restored on a physical standby database.
• B. Backups of control files taken on the primary database may not be restored and used on a physical standby database.
• C. Backups of SPFILEs taken on a physical standby database may not be restored on the primary database.
• D. Backups of control files taken on a physical standby database may be restored on the primary database.
• E. Backups of data files taken on a physical standby database may be restored on a pnmary database.
• F. Backups of SPFILEs taken on the primary database may not be restored and used on a physical standby database.

Answer: CEF

NEW QUESTION 8
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 9
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 10
Your Data Guard environment has two remote physical standby databases.
Client applications use the local naming method to define connectivity to the primary database instance.
Which will automatically redirect clients to the new primary database in case of a switchover or failover?

• A. Create a database service on the standby databases; automate the start of the service after a role change, and modify the connection description on the clients to use that service.
• B. Configure a PRIMARY role service on the Primary and Standby and modify the Client connect descriptor to include both Primary and the Standby.
• C. Set the DB_NAME parameter identically on all databases; modify the connection descriptor on the clients to use DB_NAME to connect to the primary database instance.
• D. Set the LOCALJJSTENER parameter for all the database instances, to register services with the default listener on the primary database host.

Answer: C

NEW QUESTION 11
You are licensed to use Oracle Active Data Guard
Which two statements are true after enabling block change tracking on a physical standby database?

• A. it allows fast incremental backups to be offloaded to the physical standby database
• B. It starts the CTWR process on the physical standby database instance
• C. it allows fast incremental backups to be taken on the primary database.
• D. It starts the RVWR process on the physical standby database instance.
• E. It allows fast incremental backups to be offloaded to a snapshot standby database, when the physical standby database in converted.
• F. It starts the CTWR process on the primary database instance.

Answer: AB

NEW QUESTION 12
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 13
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 14
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 15
Which two are prerequisites for configuring Transaction Guard in a Data Guard environment?

• A. Grant execute permission on the DBMS_APP_CONT package to relevant database schema owners
• B. Create a database service with COMMIT_OUTCOME set to TRUE, and ensure clients use that service to connect to the database instance.
• C. Ensure that connection descriptors for database clients use the failover clause with the COMMIT_OUTCOME parameter set to TRUE
• D. Set INSTANCE_NAME identically on all the Data Guard Configuration databases and modify the local service name on the client to include a CONNECTION_LIST containing all the standby hosts.
• E. Create a database service with COMMIT_OUTCOME set to TRUE and ensure that the service is statically registered with the default listener on the primary host

Answer: AB

NEW QUESTION 16
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 17
Examine the Data Guard configuration:
DGMGRL > show configuration; Configuration-Animals
Protection Mode MaxPerformance Databases
dogs-Primary database sheep-Snapshot standby database cats-Snapshot standby database
Fast-Start Failover: DISABLED Configuration Status: SUCCESS
You receive an error while attempting to raise the protection mode to Maximum Availability: DGMGDRL> edit configuration set protection mode as max availability;
Error ORA-16627 operation disallowed since no standby databases would remain to support protection mode Failed.
Identify two statements that you can execute, either one of which will enable successful raising of the protection mode to Maximum Availability.

• A. DGMGRL> convert database sheep to physical standby;
• B. DGMGRL> convert database cats to physical standby;
• C. DGMGRL> edit database dogs set property LogXptMode= fastsync;
• D. DGMGRL> edit database sheep set property LogXptMode= fastsync;
• E. DGMGRL> edit database cats set property LogXptMode= sync;

Answer: BE

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