1Z1-066 by Oracle Actual Free Exam Questions And Answers

Question 1

You must propose an Oracle Data Guard configuration for a database supporting an OLTP workload 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:
3. It should be possible to apply and test designated patches with a minimum amount of downtime.
4. Upgrading to a new database release should be performed with the least possible amount of downtime.
5. New application software releases should be tested against an exact up-to-date replica of the production database.
You propose a primary database with one physical standby database configured in Maximum Protection mode.
Which requirements do you meet?

A. only requirement 1

B. only requirement 5

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

D. 1 and 2

E. 2, 3, 4, and 5

Discussion 0

Correct Answer: D Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 2

Which three are true regarding prerequisites for a logical standby database as a disaster recovery solution?
(Choose three.)

A. Ensure that no ROWID data types are contained in the primary database.

B. Do not perform any nologging operations on the primary.

C. Ensure that flashback is enabled on the primary database.

D. Ensure that no BFILE LOB data types are contained in the primary database.

E. Ensure that supplemental logging is enabled on the primary database.

Discussion 0

Correct Answer: C,D Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 3

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

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

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

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

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

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

Discussion 0

Correct Answer: B,D Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 4

Which two statements are true about Far Sync instances? (Choose two.)

A. They work in Maximum Performance mode.

B. They work in Maximum Protection mode.

C. They do not work with Snapshot Standby databases.

D. They do not work with Logical Standby databases.

E. They work in Maximum Availability mode.

Discussion 0

Correct Answer: B,E Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 5

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 Availability

B. SYNC NOAFFIRM and Maximum Availability

C. ASYNC and Maximum Performance

D. SYNC NOAFFIRM and Maximum Protection

E. SYNC AFFIRM and Maximum Protection

Discussion 0

Correct Answer: A Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 6

Which two are true about the use of RMAN recovery catalogs when offloading backups to a physical standby database? (Choose two.)

A. Primary and physical standby database may use different virtual recovery catalogs in the same physical recovery catalog.

B. The primary and physical standby databases must be registered separately in the recovery catalog, if a far sync instance is used to route redo to the physical standby database.

C. It is not necessary to use a recovery catalog unless a far sync instance is used to route redo to the physical standby database.

D. It backups that are offloaded to a physical standby database are taken when not connected to a recovery catalog, then they may still be used for restoration on the primary database.

E. The physical standby database may be used to register the database in the recovery catalog, if the primary is not registered.

Discussion 0

Correct Answer: A,C Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 7

A query on the view DBA_LOGSTBY_UNSUPPORTED on your primary database returns no rows.
As a result of this, you decide that an upgrade may use logical standby databases.
Which two are true about upgrading Data Guard environments consisting of one logical standby database running on a separate host from the primary? (Choose two.)

A. Using manual upgrade, catupgrd.sql needs to run on the primary database only.

B. The upgrade always requires downtown until the upgrade of the logical standby is completed.

C. The upgrade always required downtime until the upgrade of the primary is completed.

D. SQL Apply on the local standby database must be stopped while the primary database is upgraded.

E. Using manual upgrade, catctl.pl can be executed in some cases on the primary and standby database simultaneously.

F. Fast-Start Failover can be used to protect the primary database during the upgrade.

Discussion 0

Correct Answer: D,E Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Oracle Database 12c: Data Guard Administrator - 1Z1-066 Exam Practice Test

Contact Us

Useful Links

Latest Updated