1Z0-066 Online Practice Questions and Answers

Which two statements are true about Real-Time Query?

A. Setting STANDBY_MAX_DATA_DELAY =0 requires synchronous redo transport.

B. Disabling Real-Time Query prevents the automatic start of redo apply when a physical standby database is opened READ ONLY.

C. Real-Time Query sessions can be connected to a Far Sync instance.

D. Real-Time Query has no limitations regarding the protection level of the Data Guard environment.

E. A standby database enabled for Real-Time Query cannot be the Fast-Start Failover target of the Data Guard configuration.

Which three statements are true about standby redo logs in a Data Guard configuration with no Oracle Streams or Goldengate configured?

A. They are required on a logical standby for real-time apply

B. They are required only for synchronous redo transport.

C. Only standby databases can write redo to them.

D. It is recommended to have them on the primary database.

E. They are required on a physical standby for real-time apply.

F. The LGWR process writes to them on a standby database.

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;

Which three are true concerning database states after a successful switchover?

A. If the former primary database became a logical standby database it will be in mount state

B. The new primary database will be open read-write.

C. The former primary database will always be open.

D. If the former primary database became a logical standby database it will be open read- write.

E. if the former primary database became a physical standby database it will always be open read-only.

F. If the former primary database became a physical standby database it will be in the same state as the former physical standby database

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

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 the Data Guard configuration: DGMGRL> show configuration Configuration -Animals Protection Mode: MaxAvailability Databases: dogs- Primary database sheep- (*) Physical standby database

cats- Physical standby database Fast-Start Failover: ENABLED Configuration Status: SUCCESS What happens if you issue "switchover" to sheep;" at the DGMGRL prompt?

A. The switchover succeeds but Dogs need to be reinstated

B. The switchover succeeds but Fast-Start Failover is suspended.

C. The switchover succeeds and Cats become the new failover target.

D. The switchover succeeds and Dogs become the new failover target

E. it results in an error indicating that a switchover is not allowed.

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.

Which two are prerequisites for enabling Automatic Block Media Recovery in a Data Guard environment consisting of a primary database, one physical standby database and one logical standby database?

A. FLASHBACK DATABASE must be enabled on the physical standby database.

B. There must be connectivity between the primary and the physical standby database.

C. FLASHBACK DATABASE must be enabled on the primary database.

D. The physical standby database must have Real-Time Apply enabled.

E. The logical standby database must have Real-Time Query enabled

Which two steps must be performed before running DUPLICATE TARGET DATABASE FOR STANDBY using RMAN? (Choose two.)

A. Transfer a copy of the passwordfile from the primary host to the standby host.

B. Run the nid utility to modify the DBID of the primary database.

C. Create an SPFILE for the standby database.

D. Configure Oracle Net connectivity between the primary host and the standby host.

E. Create a standby controlfile.