Question 1

Which feature of Oracle Active Data Guard allows for automatic block correction on the standby database?

Options :

A :

Real-Time Apply

B :

Active Data Guard Broker

C :

Far Sync

D :

Flashback Database

Answer: A

Question 2

What are the primary components of Oracle Data Guard?

Options :

A :

Primary database, auxiliary database, and flash recovery area.

B :

Control file, data file, and redo log file.

C :

Primary database, standby database, and observer.

D :

Physical standby database, logical standby database, and snapshot standby database.

Answer: C

Question 3

Can read-only transactions be performed on a standby database in Oracle Active Data Guard?

Options :

A :

No, read-only transactions are not supported on a standby database.

B :

Read-only transactions can only be performed if the standby database is configured as a logical standby.

C :

Read-only transactions can only be performed if the standby database is in a read-write mode.

D :

Yes, read-only transactions can be performed on a standby database.

Answer: D

Question 4

Which configuration option is required to enable Oracle Active Data Guard for read-only standby databases?

Options :

A :

Snapshot Standby

B :

Redo Apply

C :

SQL Apply

D :

Logical Standby

Answer: C

Question 5

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

Free 1Z0-076 Mock Exam – Practice Online Confidently

Buying Options: