Exam 1z0-066 All QuestionsBrowse all questions from this exam
Question 94

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

    Correct Answer: A, C, E

    To ensure a logical standby database functions correctly as a disaster recovery solution, it is important to ensure that no ROWID data types are contained in the primary database, as these are not supported by logical standby databases. Additionally, supplemental logging must be enabled on the primary database to guarantee that the necessary changes are logged and can be applied to the standby database. Lastly, BFILE LOB data types should not be used in the primary database because they are also not supported by logical standby databases.

Discussion
RockficsOptions: 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

ScottLOptions: ADE

A,D,E - I was initially choosing C; however, supplemental logging is automatically enabled when DBMS_LOGSTDBY.BUILD is executed in the primary.

JorgeZGOptions: AD

A, D and E