Online 1Z0-076 Practice Test

Question 1

What is the role of the Standby database in Oracle Data Guard?

Options :

A :

It serves as a production database for reporting purposes.

B :

It manages the network connectivity for the Primary database.

C :

It provides a read-only copy of the Primary database.

D :

It acts as a backup for the Primary database in case of failure.

Answer: C

Question 2

What is the purpose of the redo transport service in Oracle Data Guard?

Options :

A :

To transport data files from the primary database to the standby database.

B :

To transport backup files from the primary database to the standby database.

C :

To transport control files from the primary database to the standby database.

D :

To transport redo data from the primary database to the standby database.

Answer: D

Question 3

Which Data Guard protection mode ensures zero data loss in the event of a primary database failure?

Options :

A :

Maximum Performance

B :

Maximum Availability

C :

Maximum Durability

D :

Maximum Protection

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

Which SQL command is used to create a Snapshot Standby database in Oracle Data Guard?

Options :

A :

CREATE DATABASE AS SNAPSHOT STANDBY FROM PRIMARY DATABASE;

B :

ALTER DATABASE CREATE STANDBY DATABASE AS SNAPSHOT;

C :

CREATE SNAPSHOT STANDBY DATABASE FROM ACTIVE DATABASE;

D :

CREATE SNAPSHOT STANDBY DATABASE;

Answer: D

EXPERTY DESIGNED 1Z0-076 PRACTICE TEST