1Z0-066 Online Practice Questions and Answers

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.

You are required to change the Data Guard Configuration protection mode from MAXPERFORMANCE to MAXAVAJLABILITY using Enterprise Manager Cloud Control

Which two are true about this change?

A. If the primary database cannot write its redo to at least one synchronized standby database, then the protection level remains unchanged.

B. The primary database instance will remain up and running, if it cannot write redo to at least one synchronized standby database.

C. Transactions will not commit until all redo data needed to recover those transactions are written to the online redo log, and to the standby redo log on at least one synchronizes standby database.

D. Fast start failover can be enabled when making the chance.

E. Real time apply will be automatically turned on.

Which three steps are prerequisites for the creation of a physical standby database on a separate server using the RMAN active database duplication method?

A. Set the DB_UNIQUE_NAME parameter on the primary database to a different value than that of the DB_NAME parameter.

B. Put the primary database into archivelog mode

C. Startup nomount the standby database instance.

D. Configure Oracle Net connectivity on the primary host to the standby database instance.

E. Establish user equivalence for the database software owner between the primary host and standby host.

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.

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.

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

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;

Which statement is true regarding Oracle Net connectivity for a Data Guard Broker configuration?

A. To start SQL apply on a logical standby database, a TNS entry enabling connectivity to the primary database instance must be defined on the logical standby database host.

B. the LOCALJJSTERNER initialization parameter must be set to the listener used to register the primary database instance.

C. To enable Reatime Query on a physical standby database, a TNS entry enabling connectivity to the standby database instance must be defined on the primary database host.

D. A TNS enabling connectivity to the primary database instance must be defined on each of the standby database hosts.

E. A TNS entry or entries enabling connectivity to standby database instance(s) must be defined on the primary database host.

You must configure an Oracle Data Guard environment consisting of:

1. A primary database

2 One Physical Standby Database

3. One Logical 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 both the primary database and at least one standby database.

Which redo transport mode and which protection mode would 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

The Oracle database 12c Observer is currently running on host1 and you wish to have it running on host2.

Examine this list of possible steps:

1) Stop the observer on host1.

2) Disable Fast-Start Failover.

3) Update the broker configuration with the new observer hostname.

4) Enable Fast-Start Failover.

5) Start the Observer on host2.

Which contains the minimum required steps to move the observer to host2?

A. Execute only task 5.

B. Execute tasks 1, 3, and 5.

C. Execute tasks 1, 2, 3, 4, and 5.

D. Execute tasks 1 and 5.