Weekend Sale Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: ac4s65

A Data Guard environment has this configuration and these attributes:The primary database prima is in...

Oracle 1z0-076 Full Course Access
Oracle 1z0-076 View All 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?

A.

The sequence is usable on physt1 and physt2.

B.

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

C.

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

D.

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

E.

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

1z0-076 PDF/Engine
  • Printable Format
  • Value of Money
  • 100% Pass Assurance
  • Verified Answers
  • Researched by Industry Experts
  • Based on Real Exams Scenarios
  • 100% Real Questions
buy now 1z0-076 pdf
Get 65% Discount on All Products, Use Coupon: "ac4s65"
Next
Which THREE statements are TRUE about the supported workload in Active Data Guard standby databases?