Oracle Database 11g: Administration II — Question 2

In what state are the datafiles of a tablespace after a TSPITR has been successfully completed?

Answer options

• A. The datafiles have an ONLINE status.
• B. The datafiles have an OFFLINE status.
• C. The datafiles have an ONLINE status and are in hot backup mode prepared for an online backup.
• D. The datafiles have an OFFLINE status and are in hot backup mode for an online backup.
• E. The datafiles are in STANDBY mode.

Correct answer: A

Explanation

After a successful TSPITR, the datafiles are in an ONLINE status, meaning they are accessible for use. The other options incorrectly state the status as OFFLINE or in hot backup mode, which would not be the case once the TSPITR process is complete.