1Z0-066 Online Practice Questions and Answers

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

Which three are always benefits of using a logical standby database?

A. it can be used for database rolling release upgrades

B. it can be used to replicate a single pluggable database (PDB) in a multitenant container database.

C. It can be used as an updatable database for Real Application testing and then converted back to a standby database without affecting the updates.

D. It can be used for reporting workloads requiring additional indexes or materialized views or both.

E. It provides a disaster-recovery solution with switchover and failover options that can recover any data updated on the primary database.

F. it can be used for testing patches without affecting the primary database.

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 Guard environment has this configuration and these attributes:

1.

The primary database prima is in the local region.

2.

A physical standby database physt1 is in the local region.

3.

A physical standby database physt2 is in a remote region.

4.

The primary ships redo to physt1.

5.

physt1 ships redo physt2.

6.

physt1 and physt2 have Real-Time Query enabled

A sequence has been created with this SQL statement in the primary database: CREATE SEQUENCE a NOCACHE SESSION: Which two statements are true?

A. The sequence is usable on physt1 and physt2

B. The sequence is usable on physt1 but not usable on physt2.

C. The sequence is usable on physt2 if physt1 becomes unavailable, but only if an alternative redo destination has been configured on the primary database.

D. physt2 will no longer receive redo if phystl becomes unavailable, unless LOG_ARCHIVE_DEST_n has the ALTERNATE attribute specified on the primary database.

E. physt2 will no longer receive redo if physt1 becomes unavailable, unless LOG_ARCHIVE_DEST_n has the ALTERNATE attribute specified on physt1.

Which three are always benefits of using a logical standby database?

A. it can be used for database rolling release upgrades

B. it can be used to replicate a single pluggable database (PDB) in a multitenant container database.

C. It can be used as an updatable database for Real Application testing and then converted back to a standby database without affecting the updates.

D. It can be used for reporting workloads requiring additional indexes or materialized views or both.

E. It provides a disaster-recovery solution with switchover and failover options that can recover any data updated on the primary database.

F. it can be used for testing patches without affecting the primary database.

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.

Examine the Data Guard configuration: Configuration Status: SUCCESS

Which two are true?

A. The observer must run on host ol5.example com and is currently not running.

B. The observer will reinstate Sheep automatically after a failover, if required.

C. The observer will mark another standby database as the failover target if the original failover target becomes unavailable.

D. The observer will detect if the primary database is unable to accept new connections

E. The former primary database will not be reinstated automatically alter a failover.

You must design an Oracle Data Guard configuration for an OLTP database 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:

1.

It should be possible to apply designated patches with a minimum amount of downtime.

2.

Upgrading to a new database release should be performed with the least possible amount of downtime.

3.

New application software releases should be tested against an exact and up-to-date replica of the primary database.

Which configuration meets these requirements with the fewest databases?

A. a primary database with three physical standby databases

B. a primary database with one logical and two physical standby databases

C. a primary database with one logical standby database

D. a primary database with one logical and one physical standby database

E. a primary database with two physical standby databases

F. a primary database with one physical 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 two are true about Data Guard Broker configuration parameter administration? (Choose two.)

A. Changes to database properties always result in immediate updates to initialization parameters in the SPFILE even when the configuration is disabled.

B. Changes to database properties that might result in changes to static initialization parameters may not be done using the Data Guard Broker.

C. Changes to database properties that might result in changes to dynamic initialization parameters may be done using the Data Guard Broker when the configuration is disabled.

D. An SPFILE must be used for all the databases in a configuration.

E. Changes to database initialization parameters cannot be done directly for properties that are controlled by the Data Guard Broker.