Oracle Exam 1Z0-076 Topic 13 Question 34 Discussion

Actual exam question for Oracle's 1Z0-076 exam

Question #: 34
Topic #: 13

[All 1Z0-076 Questions]

A Data Guard environment has this configuration and these attributes:

The primary database prima is in the local region.

A physical standby database physt1 is in the local region.

A physical standby database physt2 is in a remote region.

The primary ships redo to physt1.

physt1 ships redo to physt2.

physt1 and physt2 have Real-Time Query enabled.

A sequence has been created with this SQL statement in the primary database:

CREATE SEQUENCE a NOCACHE SESSION;

Which TWO statements are TRUE?

AThe sequence is usable on physt1 and physt2.

BThe sequence is usable on physt2 if physt1 becomes unavailable, but only if an alternate redo destination has been configured on the primary database.

Cphyst2 will no longer receive redo if physt1 becomes unavailable, unless LOG_ARCHIVE_DEST_n has the ALTERNATE attribute specified on the primary database.

Dphyst2 will no longer receive redo if physt1 becomes unavailable, unless LOG_ARCHIVE_DEST_n has the ALTERNATE attribute specified on physt1.

EThe sequence is usable on physt1 but not usable on physt2.

Show Suggested Answer

Suggested Answer: A, C

by Emilio at Jun 15, 2025, 02:19 AM

Limited Time Offer

25%

Off

Get Premium 1Z0-076 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!