exam questions

Exam 1z0-066 All Questions

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

Exam 1z0-066 topic 1 question 33 discussion

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

Which two are true about the usage of DBMS_ROLLING?

  • A. The leading group contains the original primary database.
  • B. The trailing group contains the original primary database.
  • C. The background process DMON must be enabled on all database instances that take part in the rolling release upgrade process.
  • D. At least one logical standby database must be part of the initial Data Guard configuration.
  • E. The trailing group can contain standby databases that will protect the original primary database during the rolling release upgrade process.
Show Suggested Answer Hide Answer
Suggested Answer: DE 🗳️
E: The trailing group contains the original primary database and standby databases that will protect the original primary during the rolling upgrade process.
D: Databases in the leading group are upgraded first; hence the name leading group. The leading group contains the designated future primary database, and the physical standbys that you can configure to protect the designated future primary. The future primary is first converted into a logical standby database and then the new database software is installed on it and the upgrade process is run. Other standby databases in the leading group also must have their software upgraded at this point.
Note: To upgrade the database software in an Oracle Data Guard configuration in a rolling fashion, you first designate a physical standby as the future primary database.
Conceptually, the rolling upgrade process splits the Oracle Data Guard configuration into two groups: the leading group (LG) and the trailing group (TG).
Incorrect Answers:
A: The leading group contains the designated future primary database, and the physical standbys that you can configure to protect the designated future primary.
References:
https://docs.oracle.com/database/121/SBYDB/dbms_rolling_upgrades.htm#SBYDB5431

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
jorche
Highly Voted 2 years, 3 months ago
Answer: B and E The trailing group contains the original primary database and standby databases that protect the original primary during the rolling upgrade process. While the databases in the leading group are going through the upgrade process, user applications can still be connected to the original primary and making changes https://docs.oracle.com/database/121/SBYDB/dbms_rolling_upgrades.htm#SBYDB5431
upvoted 6 times
...
piontk
Most Recent 11 months, 3 weeks ago
Selected Answer: BE
"The trailing group contains the original primary database and standby databases that protect the original primary during the rolling upgrade process" https://docs.oracle.com/en/database/oracle/oracle-database/19/sbydb/using-DBMS_ROLLING-to-perform-rolling-upgrade.html#GUID-647FF758-5B53-44AE-BB80-B6FA506F09C7
upvoted 1 times
...
JESUSBB
2 years, 5 months ago
Answer: D and E
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
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago