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

Question 1

Which three are prerequisites for enabling Fast-Start Failover? (Choose three.)

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

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

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

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

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

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

Discussion 0

Correct Answer: C,D,E Vote an answer

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

Question 2

Which three are true about the use of the VALID_FOR clause of the LOG_ARCHIVE_DEST_N parameter, in determining whether archive logs should be written to a particular destination by a database in a Data Guard environment? (Choose three.)

A. whether the database at the destination is reached by using a far sync instance

B. whether standby redo logs are to be archived at a specific destination

C. whether the database at the source is a primary or a standby

D. whether the database at the destination is a primary or a standby

E. whether online redo logs are to be archived at a specific destination

Discussion 0

Correct Answer: A,B,C Vote an answer

Question 3

Which three statements are true about Data Guard configurations? (Choose three.)

A. The Oracle recommendation for the number of standby redo log groups per thread is one more than the number of online redo log groups per thread.

B. For Standard Edition, LOG_ARCHIVE_DUPLEX_DEST is used to configure redo transport, from the primary to the standby database.

C. Up to 30 physical standby databases may exist within one configuration.

D. VALID_FOR is a LOG_ARCHIVE_DEST_N attribute that enables DB role change operations without having to modify LOG_ARCHIVE_DEST_n when performing switchovers or failovers.

E. All databases in one Data Guard environment must have the same database name.

F. When using the Data Guard Broker, an spfile is not required.

Discussion 0

Correct Answer: A,C,E Vote an answer

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

Question 4

Which statement is true regarding Oracle Net connectivity for a Data Guard Broker configuration?

A. A TNS entry or entries enabling connectivity to standby database instance(s) must be defined on the primary database host.

B. To enable Real_Time Query on a physical standby database, a TNS entry enabling connectivity to the standby database instance must be defined on the primary database host.

C. A TNS enabling connectivity to the primary database instance must be defined on each of the standby database hosts.

D. To start SQL apply on a logical standby database, a TNS entry enabling connectivity to the primary database instance must be defined on the logical standby database host.

E. the LOCAL_LISTENER initialization parameter must be set to the listener used to register the primary database instance.

Discussion 0

Correct Answer: C Vote an answer

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

Question 5

Which three statements are true about Data Guard database modes and states? (Choose three.)

A. Databases in a Data Guard Configuration need not operate in Flashback Logging mode.

B. A Logical Standby Database can be in MOUNT state while applying changes.

C. A primary database may ship redo directly to more than mine standby databases.

D. Force Logging Mode is not required for a primary database but is recommended.

E. The Primary Database can operate in noarchivelog mode.

Discussion 0

Correct Answer: B,C,D Vote an answer

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

Question 6

Which two Data Guard features require the use of flashback database by the broker? (Choose two.)

A. Fast-Start Failover

B. Far Sync Instances

C. Read-Mostly physical standby implementations

D. Real Time Query

E. Snapshot Standby databases

Discussion 0

Correct Answer: A,E Vote an answer

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

Question 7

Examine this query and its output:
SQL> select fs_failover_status, fs_failover_current_target,
2 fs_failover_observer_present, fs_failover_oserver_host
3 from v$database:
FS_FAILOVER_STATUS FS_FAILOVER_CURRENT_TARGET
------------------ --------------------------
BYSTANDER cats
FS_FAILOVER_OBSERVER_PRESENT FS_FAILOVER_OBSERVER_HOST
---------------------------- -------------------------
NO ol7.example.com
Which are true?

A. The observer is not connected to the database on which the query was executed.

B. The observer is not running, but should run on ol7.example.com.

C. The observer is connected to the database on which the query was executed.

D. Cats is a bystander database.

E. The observer is currently running on ol7.example.com.

Discussion 0

Correct Answer: A Vote an answer

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

Question 8

Which two are true about database roles in an Oracle Data Guard Configuration? (Choose two.)

A. A Snapshot Standby Database can be a fast-start failover target.

B. A Logical Standby Database can be converted to a Snapshot Standby Database.

C. A Logical Standby Database can cascade redo to a terminal destination.

D. A Physical Standby Database can be converted into a Logical Standby Database.

E. A configuration consisting only of a primary and one or more physical standby databases can support a rolling release upgrade.

Discussion 0

Correct Answer: B,D Vote an answer

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

Question 9

Which two are prerequisites for creating a standby database using Enterprise Manager cloud control? (Choose two.)

A. The primary database must have flashback enabled.

B. The primary database must have FORCE LOGGING enabled.

C. The primary database instance must be started using an SPFILE.

D. A backup of the primary database must exist.

E. The primary database must be in archivelog mode.

F. The primary host and the proposed standby database host must run the same operating system.

Discussion 0

Correct Answer: B,E Vote an answer

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

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

Contact Us

Useful Links

Latest Updated