Question 1

What happens to a read-only transaction in a read-only standby database if the primary database fails?

Options :

A :

The transaction is queued and executed once the primary database is restored

B :

The transaction is automatically redirected to the standby database

C :

The transaction is rolled back and not applied to the standby database

D :

The transaction is permanently lost

Answer: C

Question 2

What are the two types of standby databases in Oracle Data Guard?

Options :

A :

Online and offline.

B :

Primary and secondary.

C :

Physical and logical.

D :

Active and passive.

Answer: C

Question 3

What is the recommended practice for patching a Logical Standby Database in a Data Guard environment?

Options :

A :

First, apply the patch to the Logical Standby Database, then apply it to the primary database.

B :

First, apply the patch to the primary database, then apply it to the Logical Standby Database.

C :

Apply the patch simultaneously to both the primary database and the Logical Standby Database.

D :

Patching is not recommended on a Logical Standby Database.

Answer: B

Question 4

What is the purpose of the DBMS_LOGSTDBY package in a logical standby database?

Options :

A :

To manage data backup and recovery operations

B :

To manage network connectivity between primary and standby databases

C :

To enable supplemental logging for logical replication

D :

To perform log shipping between primary and standby databases

Answer: C

Question 5

Which view can be queried to find the current state of the Data Guard configuration?

Options :

A :

V$DATABASE_STATUS

B :

V$CONFIGURATION_STATUS

C :

V$SERVER_STATUS

D :

V$DATAGUARD_STATUS

Answer: D

Free 1Z0-076 Mock Exam – Practice Online Confidently

Buying Options: