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

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

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.

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 database. D. increase the PARALLEL_MAX_SERVER initialization parameter

D. Decrease the number of PREPARER processes

E. Increase the RECOVERY_PARALLEUSM initialization parameter

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

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.

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

A data file on one of your physical standby databases has been accidentally deleted and you must restore and recover it. All the archive logs required for recovery are still on disk in the directory pointed to by the log_archive_dest_1 parameter Which three steps must be performed to restore the missing file and recover the standby database while it is in the MOUNT state?

A. Recover the datafile by using the RMAN RECOVER DATAFILE command

B. Restart the redo apply.

C. Restore the datafile by using the RMAN RESTORE DATAFILE command.

D. Stop the redo apply.

E. Recover the database by using the RMAN RECOVER DATABASE command.

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 database. D. increase the PARALLEL_MAX_SERVER initialization parameter

D. Decrease the number of PREPARER processes

E. Increase the RECOVERY_PARALLEUSM initialization parameter

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