Oracle Database Administration II — Question 165

Which three are true about recovering tables using RMAN? (Choose three.)

Answer options

• A. RMAN can recover tables owned by the SYS user.
• B. RMAN can recover tables in the SYSAUX tablespace.
• C. RMAN can recover tables owned by the SYSTEM user.
• D. RMAN can recover a table after a DDL operation has altered the table structure.
• E. RMAN can recover tables in the SYSTEM tablespace.
• F. RMAN can recover tables in a standby database.
• G. RMAN always uses an auxiliary instance.

Correct answer: C, D, G

Explanation

The correct answers, C, D, and G, reflect RMAN's capabilities in recovering tables owned by the SYSTEM user, recovering tables after DDL changes, and always requiring an auxiliary instance for certain operations. Options A, B, E, and F are incorrect because RMAN does not support recovery for SYS user tables or specific tablespaces like SYSAUX or SYSTEM, and while it can recover from standby databases, the focus on the specified options is what makes them inaccurate in this context.