Which two statements are true?

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?

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?

A.
The sequence is usable on physt1 and physt2.

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

C.
The sequence is usable on physt2 if physt1 becomes unavailable, but only if an alternative redo destination
has been configured 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 the primary database.

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

Explanation:
Note: LOG_ARCHIVE_DEST_n specifies an alternate archiving destination to be used when the original
destination fails.
The ALTERNATE attribute is optional. If an alternate destination is not specified, then redo transport services
do not automatically change to another destination if the original destination fails.
https://docs.oracle.com/cd/B28359_01/server.111/b28294/log_arch_dest_param.htm
https://docs.oracle.com/database/121/SQLRF/statements_6017.htm#SQLRF01314

Show Hint

Leave a Reply 4

Your email address will not be published. Required fields are marked *

Chunn

Chunn

Correct Ans: A, D

I have tested this.

This is a session sequence and Real-time query is enabled so it is accessible on both physt1 and physt2.

Configuration is setup for Cascaded Redo so unless ALTERNATE attribute should be defined in the Primary database to directly send the redo to physt2 when physt1 becomes unavailable. However, since it is a session sequence, you can still access the sequence in physt2 without a problem if physt1 goes down.

Reply