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 20 discussion

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

Which three statements are true about Global Sequences when connected to a physical standby database with Real-Time Query enabled?

  • A. If the CACHE option is set then the size of the cache must be at least 100.
  • B. Their creation requires that a LOG_ARCHIVE_DEST_n parameter be defined in the standby that points back to their primary.
  • C. Their usage will always have a performance impact on the primary database.
  • D. Their usage may have a performance impact on the physical standby database if the CACHE size is too small
  • E. They must have the NOORDER and CACHE options set.
Show Suggested Answer Hide Answer
Suggested Answer: BDE 🗳️
B: the terminal standby should have a LOG_ARCHIVE_DEST_n parameter defined that points back to the primary.
D: Because the standby's requests for a range of sequences involve a round-trip to the primary, be sure to specify a large enough value for the CACHE keyword when you create a sequence that will be used on an Oracle Active Data Guard standby. Otherwise, performance could suffer.
E: In an Oracle Active Data Guard environment, sequences created by the primary database with the default CACHE and NOORDER options can be accessed from standby databases as well.
References:
https://docs.oracle.com/database/121/SBYDB/manage_ps.htm#SBYDB5164
by JESUSBB at Aug. 27, 2022, 2:44 a.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
Rockfics
1 year, 3 months ago
Log Archive Dest is not required with Global Cache. A number of minimal Cache is not required too. Answer C,D,E
upvoted 1 times
...
JESUSBB
1 year, 9 months ago
Answer: B, D and E
upvoted 2 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