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

Which three statements are true about snapshot standby databases?

Answer options

• A. Tablespaces can be dropped.
• B. Tables can be dropped.
• C. The broker may be used to fail over to a snapshot standby database.
• D. A logical standby database can be converted into a snapshot standby database.
• E. Tablespaces can be created.

Correct answer: A, B, E

Explanation

The correct statements are A, B, and E because in a snapshot standby database, both tables and tablespaces can be removed, and new tablespaces can be created for specific purposes. However, option C is incorrect as the broker is not typically used for failing over to a snapshot standby, and option D is false because a logical standby cannot be directly converted into a snapshot standby.