Which three statements are true about snapshot standby databases?
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.
Answer: CE
Which three statements are true about Global Sequences when connected to a physical standby database with Real-Time Query enabled?
A. If the CACHE option is set then the size of the cache must be at least 100.
B. Their creation requires that a LOG_ARCHIVE_DEST_n parameter be defined in the standby that points back to their primary.
C. Their usage will always have a performance impact on the primary database.
D. Their usage may have a performance impact on the physical standby database if the CACHE size is too small
E. They must have the NOORDER and CACHE options set.
Answer: BDE
