Question 1

Can a read-only standby database be promoted to a primary database?

Options :

A :

Yes, a read-only standby database can be promoted to a primary database.

B :

No, a read-only standby database cannot be promoted to a primary database.

Answer: B

Question 2

What is the main benefit of offloading read-only workloads to a standby database?

Options :

A :

Reduced load on the primary database

B :

Improved performance on the primary database

C :

Simplified management of database backups

D :

Enhanced security for read-only data

Answer: A

Question 3

Which Oracle Data Guard feature is NOT supported on a snapshot standby database?

Options :

A :

Far Sync

B :

Fast-Start Failover

C :

Broker Configurations

D :

Real-Time Apply

Answer: D

Question 4

Which Oracle Data Guard mode allows real-time synchronization between the primary and standby databases?

Options :

A :

Maximum Protection mode

B :

Maximum Readability mode

C :

Maximum Performance mode

D :

Maximum Availability mode

Answer: A

Question 5

What is a switchover operation in Oracle Data Guard?

Options :

A :

A network failover operation between the Primary and Standby databases.

B :

A shutdown and startup operation for the Primary database.

C :

A planned role reversal between the Primary and Standby databases.

D :

A failover operation from Primary to Standby database in case of failure.

Answer: C

Higher Test Marks with Free Online 1Z0-076 Exam Practice

Buying Options: