exam questions

Exam 1z0-066 All Questions

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

Exam 1z0-066 topic 1 question 102 discussion

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

Which three are true regarding prerequisites for a logical standby database as a disaster recovery solution? (Choose three.)

  • A. Ensure that no ROWID data types are contained in the primary database.
  • B. Ensure that flashback is enabled on the primary database.
  • C. Ensure that supplemental logging is enabled on the primary database.
  • D. Do not perform any nologging operations on the primary.
  • E. Ensure that no BFILE LOB data types are contained in the primary database.
Show Suggested Answer Hide Answer
Suggested Answer: BE 🗳️

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
Seba1494
3 months ago
Selected Answer: AD
C i incorect beacuse: When you execute the DBMS_LOGSTDBY.BUILDprocedure, the LogMiner dictionary is built and supplemental logging is automatically enabled for logging primary key and unique key columns. Supplemental logging ensures that each update contains enough information to logically identify the affected row.
upvoted 1 times
...
Rockfics
1 year, 5 months ago
Selected Answer: AC
ACE Is log Miner is not build, not supplemental logging is not enable. So is mandatory supplemental logging with Log Miner. No logging operations can be execute but is FORCE Logging set is ok
upvoted 1 times
...
ScottL
1 year, 6 months ago
A,D,E - I was initially choosing C; however, supplemental logging is automatically enabled when DBMS_LOGSTDBY.BUILD is executed in the primary.
upvoted 1 times
...
JorgeZG
2 years, 1 month ago
Selected Answer: AD
A, 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