Oracle Database 12c: RAC and Grid Infrastructure Administration — Question 6

Which three statements are true about snapshot standby databases?

Answer options

• A. Snapshot standby databases may be used for rolling release upgrades.
• B. If datafiles grow while a database is a snapshot standby database, then they shrink when converted back to a physical standby database.
• C. Flashback logs are used to convert a snapshot standby database back into a physical standby database.
• D. A snapshot standby database can have Real-Time Query enabled.
• E. A guaranteed restore point is created automatically when a physical standby database is converted into a snapshot standby database.

Correct answer: C, E

Explanation

The correct answer, C, is true because flashback logs are essential for the conversion process back to a physical standby. E is also correct since a guaranteed restore point is automatically created during the conversion. A and B are incorrect as they do not accurately reflect the capabilities or behaviors of snapshot standby databases.