ExamTopics Logo
Mail Us[email protected]
Menu
Oracle Discussions
exam questions

Exam 1z0-066 All Questions

View all questions & answers for the 1z0-066 exam
Go to Exam

Exam 1z0-066 topic 1 question 39 discussion

Actual exam question from Oracle's 1z0-066
Question #: 39
Topic #: 1
[All 1z0-066 Questions]

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.
Show Suggested Answer Hide Answer
Suggested Answer: AD 🗳️
by ra2020 at May 17, 2020, 4:28 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
piontk
11 months, 3 weeks ago
Selected Answer: 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
upvoted 1 times
...
Rockfics
1 year, 3 months ago
Selected Answer: CD
A and C can be, but C and D are most especific.
upvoted 1 times
...
JorgeZG
1 year, 11 months ago
Selected Answer: AD
I think it's A and D
upvoted 3 times
...
mikom80
3 years, 2 months ago
Selected Answer: 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
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago