Oracle Database Application Development

Free Share 1z0-066 Exam Dumps and Practice Questions and Answers

Attention please! Here is the shortcut to pass your 1z0-066 exam! Get yourself well prepared for the Oracle Database Application Development 1z0-066 Oracle Database 12c: Data Guard Administrator exam is really a hard job. But don’t worry! We We, provides the most update 1z0-066 vce. With We latest latest 1z0-066 dumps, you’ll pass the Oracle Database Application Development 1z0-066 Oracle Database 12c: Data Guard Administrator exam in an easy way

Visit our site to get more 1z0-066 Q and As:https://www.itcertbible.com/1z0-066.html (204 QAs Dumps)
Question 1:

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.

Correct Answer: BD


Question 2:

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.

Correct Answer: ACE


Question 3:

Your Data Guard environment has one physical standby database using Real-Time Query.

Two sentences have been created by these SQL statements:

create sequence a global; create sequence b session;

Neither sequence has been used since being created Session 1 connects to the primary database instance and issues these two SQL statements:

SELECT a.nextval FROM DUAL;

SELECT b nextval FROM DUAL;

Then session 2 connects to the physical standby database instance and issues the same SQL statements.

What output will be seen for session 2?

A. Option A

B. Option B

C. Option C

D. Option D

Correct Answer: C


Question 4:

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.

Correct Answer: ABC


Question 5:

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.

Correct Answer: CEF


Question 6:

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;

Correct Answer: BE


Question 7:

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.

Correct Answer: ADE


Question 8:

Which two are true about management of a far sync instance when using the Data Guard Broker?

A. A far sync instance is in a disabled state in the broker configuration immediately after adding it

B. A far sync instance that has its RedoRoutes property set may not be disabled in the broker configuration.

C. Broker management of a far sync instance may only be disabled with the disable configuration DGMGRL command.

D. A far sync instance need not exist before adding it to the broker configuration but may not be enabled until created

Correct Answer: AB


Question 9:

Examine this list of possible steps:

1 Raise the compatibility level on both databases

2.Restart SQL Apply on the upgraded logical standby database

3 Start SQL Apply on the old primary database.

4.

Perform a Switchover to the logical standby database

5.

Upgrade the logical standby database.

6.

Upgrade the old primary database.

Which is the minimum number of steps in the correct order, to perform a rolling release upgrade of a data guard environment using an existing logical standby database and to enable the new functionality?

A. 5,2.4,3,6,1

B. 1,5,2,4,6,3

C. 5,2,4,6,3,1

D. 4,6,5,2,3,1

E. 5,2,4,1

Correct Answer: A


Question 10:

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.

Correct Answer: ACEG


Question 11:

In which two cases is it possible to change the protection mode to maximum protection using Enterprise Manager Cloud Control?

A. a snapshot standby database is the only standby database in the Data Guard configuration.

B. A logical standby database is the only standby database in the data guard configuration.

C. A far sync instance is the only Data Guard configuration member receiving redo in synchronous mode.

D. Flashback is not enabled for either the primary database, the standby database, or both in the Data Guard configuration.

E. The primary and standby databases are hosted on different operating systems.

Correct Answer: BE


Question 12:

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

Correct Answer: C


Question 13:

Which three are prerequisites for enabling Fast-Start Failover?

A. The Fast-Start Failover target standby database must receive REDO directly from the primary database

B. Flashback Database must be enabled on both the primary database and the Fast-Start Failover target standby database.

C. Flashback Database must be enabled only on the Fast-Start Failover target standby database.

D. The configuration must be operating in either Maximum Performance or Maximum Availability mode

E. The configuration must be operating in either Maximum Performance or Maximum Protection mode

F. The Data Guard environment must be managed by the Data Guard Broker.

Correct Answer: BDF


Question 14:

Examine the Data Guard configuration after an accidental switchover to Sheep: Which three will be true after a switchover to Dogs?

A. Sheep will be a disabled logical standby database.

B. Sheep will be an enabled logical standby database.

C. Cats will be a disabled physical standby database that can be manually enabled.

D. Cats will be an enabled physical standby database.

E. Dogs will be the primary database.

Correct Answer: BCE


Question 15:

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.

Correct Answer: BC


Visit our site to get more 1z0-066 Q and As:https://www.itcertbible.com/1z0-066.html (204 QAs Dumps)