Exam 1z0-066 All QuestionsBrowse all questions from this exam
Go to Exam
Question 39

A Data Guard environment has this configuration and these attributes:

1. The primary database prima is in the local region.

2. A physical standby database physt1 is in the local region.

3. A physical standby database physt2 is in a remote region.

4. The primary ships redo to physt1.

5. physt1 ships redo physt2.

6. 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?

    Correct Answer: A, D

    The sequence is a session-level sequence, implying it can be used independently of connectivity to the primary, making it usable on both physt1 and physt2. Additionally, physt2 will no longer receive redo if physt1 becomes unavailable unless the LOG_ARCHIVE_DEST_n has the ALTERNATE attribute specified on the primary database to redirect redo shipping.

Discussion
JorgeZGOptions: AD

I think it's A and D

piontkOptions: AD

The ALTERNATE attribute specifies an alternate archiving destination to be used when the original destination fails. ( D is correct) Since the sequence is a session sequence, it do not depend on connectivity to the primary. (A is correct) REF: https://docs.oracle.com/en/database/oracle/oracle-database/19/sbydb/managing-oracle-data-guard-physical-standby-databases.html#GUID-8A73B0A3-D77D-4CF6-ABCB-6293BB26B6D1 https://docs.oracle.com/en/database/oracle/oracle-database/19/sbydb/LOG_ARCHIVE_DEST_n-parameter-attributes.html#GUID-88222D10-22FD-4F3B-BBE5-B59C8ABEC725

RockficsOptions: CD

A and C can be, but C and D are most especific.

mikom80Options: CD

E wrong - E. physt2 will no longer receive redo if physt1 becomes unavailable, unless LOG_ARCHIVE_DEST_n has the ALTERNATE attribute specified on physt1. - if physt1 will be unavaliable, that alternate dest set on physt1 (which is unavaliable) will not help