1Z0-066 Online Practice Questions and Answers

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

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 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.

Which three are true regarding the Enterprise Manager Cloud Control Data Guard configuration verification wizard?

A. it checks that supplemental logging is turned on if there is a logical standby database in the configuration.

B. it verifies that parameter settings in the SPFILE or in memory or both, are consistent with the broker configuration properties for that database.

C. It checks that the current data protection level is consistent with the broker's configured data protection mode.

D. it modifies the database configurable parameters to match the values set for the broker configuration.

E. It generates a workload on the primary database causing log switching, and monitors the arrival rate of redo on the standby database.

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 ways to start the observer successfully

A. Set the Observer Override property to TRUE before starting the observer

B. Create a broker configuration and enable Fast-Start Failover before starting the observer

C. Start the observer using a different observer configuration file.

D. start the observer in a different working directory.

E. Enable Fast-Start Failover before starting the observer

Which two are true about the usage of DBMS_ROLLING?

A. The leading group contains the original primary database.

B. The trailing group contains the original primary database.

C. The background process DMON must be enabled on all database instances that take part in the rolling release upgrade process.

D. At least one logical standby database must be part of the initial Data Guard configuration

E. The trailing group can contain standby databases that will protect the original primary database during the rolling release upgrade process.

You must configure an Oracle Data Guard environment consisting of:

1. A primary database

2 Three Physical Standby Databases

You must meet these requirements:

A designated physical standby database should become the primary database automatically whenever the primary database falls The chosen protection mode should provide the highest level of protection possible without violating the other requirement Which redo transport mode and protection mode would you configure to meet these requirements?

A. SYNC NOAFFRIM and Maximum Protection

B. SYNC NOAFFIRM and Maximum Availability

C. ASYNC and Maximum Performance

D. SYNC AFFIRM and Maximum Availability

E. SYNC AFFIRM and Maximum Protection

Which two are true about the usage of DBMS_ROLLING?

A. The leading group contains the original primary database.

B. The trailing group contains the original primary database.

C. The background process DMON must be enabled on all database instances that take part in the rolling release upgrade process.

D. At least one logical standby database must be part of the initial Data Guard configuration

E. The trailing group can contain standby databases that will protect the original primary database during the rolling release upgrade process.

Your Data Guard environment consists of these components and settings:

1.

A primary database

2.

A remote physical standby database

3.

Real-time query is enabled

4.

The redo transport mode is set to SYNC.

5.

The protection mode is set to Maximum Availability.

You notice that queries executed on the physical standby database receive errors: ORA- 03172: STANDBY_MAX_DATA_DELAY of 15 seconds exceeded. Which two would you recommend to avoid this error?

A. Change the protection mode to Maximum Performance.

B. Increase the size of the buffer cache on the standby database instance.

C. Reduce I/O latency for the storage used by the primary database.

D. Change the protection mode to Maximum Protection.

E. Increase the network bandwidth between the primary and standby databases

F. Increase the number of standby redo log files on the primary database

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.