Question 1

Which three statements are true about Data Guard database modes and states?

Options :

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

B : The Primary Database can operate in noarchivelog mode.

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

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

E : A primary database may ship redo directly to more than nine standby databases.

Answer: A,C,D

Question 2

What is a switchover in Oracle Data Guard?

Options :

A : A process of switching the network connections between databases

B : A process of switching the roles of the Primary and Secondary databases

C : A process of synchronizing data between databases in real-time

D : A process of copying data from the Primary database to the Secondary database

Answer: B

Question 3

What is the purpose of the primary database in a logical standby configuration?

Options :

A : It serves as the standby database for a different primary database.

B : It serves as the read/write production database.

C : It provides redo data for the logical standby database.

D : It is used solely for data recovery purposes.

Answer: C

Question 4

What is the main advantage of using a snapshot standby database over a physical standby database?

Options :

A : Improved performance for reporting and queries

B : Reduced disk space requirements

C : Ability to apply redo logs to update the standby database

D : Faster failover and switchover capabilities

Answer: A

Question 5

What is the purpose of a primary database in Oracle Data Guard?

Options :

A : To serve as the backup database in case of a failure.

B : To provide read-only access to the database.

C : To handle incoming client connections and process transactions.

D : To perform real-time synchronization with the standby database.

Answer: C