Question 1

What happens when the standby redo logs are not present on the standby database?

Options :

A :

The standby database cannot be used for failover.

B :

Redo logs from the primary database are not applied to the standby database.

C :

Archive logs cannot be transferred to the standby database.

D :

The standby database operates in manual recovery mode.

Answer: B

Question 2

Which file is used to configure Oracle Net Services?

Options :

A :

spfile.ora

B :

listener.ora

C :

tnsnames.ora

D :

sqlnet.ora

Answer: B

Question 3

What happens to the changes made in a Snapshot Standby database when it is converted back to a physical standby database?

Options :

A :

The changes are discarded

B :

The changes are applied to the primary database

C :

All changes are lost

Answer: B

Question 4

What is the purpose of starting the standby database in read-only mode during the physical standby database creation process?

Options :

A :

To synchronize data between the primary and standby databases

B :

To enable real-time query on the standby database

C :

To allow read-only transactions on the standby database

D :

To perform monitoring and management tasks on the standby database

Answer: C

Question 5

What is the role of the observer in Oracle Data Guard?

Options :

A :

To monitor the health and status of the primary and standby databases.

B :

To perform automatic failover in case of a primary database failure.

C :

To compress and encrypt data during replication.

D :

To facilitate communication between the primary and standby databases.

Answer: B

Free 1Z0-076 Mock Exam – Practice Online Confidently

Buying Options: