1Z0-066 Online Practice Questions and Answers

Which three are true concerning restoring of RMAN backups to primary and physical standby databases in a Data Guard environment?

A. Backups of data files taken on the primary database may be restored on a physical standby database.

B. Backups of control files taken on the primary database may not be restored and used on a physical standby database.

C. Backups of SPFILEs taken on a physical standby database may not be restored on the primary database.

D. Backups of control files taken on a physical standby database may be restored on the primary database.

E. Backups of data files taken on a physical standby database may be restored on a pnmary database.

F. Backups of SPFILEs taken on the primary database may not be restored and used on a physical standby database.

You administer a Data Guard environment with a primary and two physical standby databases.

One of the physical standby databases is used for reporting and is on the same host as the primary database. The other physical standby database is remote, used for disaster recovery and REDO is routed to it via a

far sync instance.

Backups are offloaded to the remote physical standby.

Which three are true concerning the management of archive logs in this Data Guard configuration?

A. Archive logs on the primary database may be deleted once they are applied on all standby databases.

B. Archive logs on the primary database may be deleted once they are shipped on all standby databases.

C. The deletion policy for archive logs on the remote physical standby should be set so that archived logs are deleted once they backed up at least once on the remote physical standby database.

D. The deletion policy for archive logs on the remote physical standby should be set so that archived logs are deleted once they are applied on all standby databases.

E. Archive logs on the primary database may be deleted once they are archived locally to disk.

Which four requirements can be met by deploying a logical standby database?

A. Support for workloads requiring additional indexes.

B. it can be used to create additional schemas.

C. it can be used to create additional tables.

D. It must have the same physical structure as the primary database.

E. it must provide a disaster-recovery solution that protects all data with capability of performing switchovers and failovers.

F. Support for workloads requiring additional materialized views.

G. it can be used for Real Application Testing without affecting the disaster recovery capabilities.

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

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

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

Which three types of backups taken in which situations may be used to perform restore operations to a logical standby database in a Data Guard environment?

A. backups of data files taken on the primary database if connected to the recovery catalog where the logical standby database is registered

B. backups of data files taken on the standby database if connected to the recovery catalog where the logical standby database is registered

C. backups of control files taken on the primary database if connected to the recovery catalog where the logical standby database is registered

D. backups of data files taken on the logical standby database, if not connected to a recovery catalog

E. backups of control files taken on the logical standby database if not connected to a recovery catalog

You administer a Data Guard environment consisting of a primary and three physical standby databases.

One physical standby database is used for disaster recovery, one is used for reporting, and one is used as a replica for testing. The standby database used for testing is occasionally converted into a snapshot standby database and

then converted back to a physical standby.

The physical standby database is the only standby that is a mandatory destination

The broker configuration operates in MAXIMUM PERFORMANCE mode.

Which ARCHIVELOG DELETION POLICY should be set. so that archive logs generated on the primary

database are not deleted before they are consumed appropriately on each of the standby databases, but which allows them to be deleted form the primary as soon as it is safe to do so?

A. CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY

B. CONFIGURE ACHIVELOG DELETION POLICY TO APPLIED ON STANDBY;

C. CONFIGURE ACHIVELOG DELETION POLICY TO SHIPPED TO ALL STANDBY;

D. CONFIGURE ACHIVELOG DELETION POUCY TO SHIPPED TO STANDBY,

E. CONFIGURE ACHIVELOG DELETION POLICY TO NONE;

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

You administer a Data Guard environment with a primary and two physical standby databases.

One of the physical standby databases is used for reporting and is on the same host as the primary database. The other physical standby database is remote, used for disaster recovery and REDO is routed to it via a

far sync instance.

Backups are offloaded to the remote physical standby.

Which three are true concerning the management of archive logs in this Data Guard configuration?

A. Archive logs on the primary database may be deleted once they are applied on all standby databases.

B. Archive logs on the primary database may be deleted once they are shipped on all standby databases.

C. The deletion policy for archive logs on the remote physical standby should be set so that archived logs are deleted once they backed up at least once on the remote physical standby database.

D. The deletion policy for archive logs on the remote physical standby should be set so that archived logs are deleted once they are applied on all standby databases.

E. Archive logs on the primary database may be deleted once they are archived locally to disk.