Oracle Database 12c: Advanced Administration — Question 153

Which two statements are true about recovering logically corrupted tables or table partitions from an RMAN backup?

Answer options

• A. Tables or table partitions can be recovered by using an auxiliary instance only.
• B. Tables or table partitions with a foreign key cannot be recovered.
• C. Tables or table partitions can be recovered only when the database is in mount state.
• D. Tables or table partitions from the system and sysaux tablespaces cannot be recovered.
• E. Tables with not null constraints cannot be recovered.

Correct answer: A, D

Explanation

Option A is correct because recovering tables or table partitions requires an auxiliary instance to ensure data integrity. Option D is also true, as tables or table partitions from the system and sysaux tablespaces are not recoverable due to their critical nature. The other options are incorrect because foreign key constraints, database state, and not null constraints do not prevent recovery in the context of RMAN backups.