Oracle Database Administration II — Question 98

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

Answer options

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

Correct answer: D, F, G

Explanation

The correct answers are D, F, and G. RMAN always uses an auxiliary instance for certain recovery operations, can recover tables even after DDL modifications, and is capable of recovering tables owned by the SYSTEM user. The other options are incorrect because RMAN cannot recover tables in the SYSAUX or SYSTEM tablespaces and does not specifically target tables owned by the SYS user.