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

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

Which three are always benefits of using a logical standby database?

  • A. It can be used for database rolling release upgrades.
  • B. It can be used to replicate a single pluggable database (PDB) in a multitenant container database.
  • C. It can be used as an updatable database for Real Application testing and then converted back to a standby database without affecting the updates.
  • D. It can be used for reporting workloads requiring additional indexes or materialized views or both.
  • E. It provides a disaster-recovery solution with switchover and failover options that can recover any data updated on the primary database.
  • F. It can be used for testing patches without affecting the primary database.
Show Suggested Answer Hide Answer
Suggested Answer: CDF 🗳️
C: A logical standby database can be used to test new software releases and some kinds of applications on a complete and accurate copy of the primary's data. It can host other applications and additional schemas while protecting data replicated from the primary against local changes.
D: A logical standby database is open read/write while changes on the primary are being replicated. Consequently, a logical standby database can simultaneously be used to meet many other business requirements, for example it can run reporting workloads that would problematical for the primary's throughput.
F: Logical standby can be used to greatly reduce downtime associated with applying patchsets and new software releases. A logical standby can be upgraded to the new release and then switched over to become the active primary. This allows full availability while the old primary is converted to a logical standby and the patchset is applied.
References:
https://docs.oracle.com/cd/E11882_01/server.112/e41134/standby.htm#SBYDB00103
by Yoones at June 29, 2021, 9:34 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
ScottL
1 year, 3 months ago
A,D,E -
upvoted 1 times
...
ucdongmo
1 year, 7 months ago
A, D and E C: is the definition of snapshot database. F: Real application testing should be on a database with similar structure but logical standby database is an independent database.
upvoted 1 times
ucdongmo
1 year, 7 months ago
Sorry A, D and F
upvoted 3 times
...
...
JESUSBB
2 years, 5 months ago
Answer: A, D and E
upvoted 1 times
...
Yoones
3 years, 7 months ago
The right answers are: ADE C: is the definition of snapshot stdb not a logical stdb F: should not be correct because logical stdb is more used to rolling upgrade rather testing porpuses.
upvoted 1 times
Sugar
3 years, 3 months ago
A D E were also my answers and obviously they provided wrong answers
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