Upgrade Oracle DBA 11g to Oracle Database 12c — Question 15

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 sysauxtablespaces 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 partitions typically requires an auxiliary instance to avoid conflicts. Option D is also correct since system and sysauxtablespaces are critical for database operation and their contents cannot be restored in this manner. The other options present incorrect restrictions or conditions that do not apply to the recovery process.