Oracle Database 11g: Administration I — Question 38

Which of these is true about undo tablespace?

Answer options

• A. Undo tablespace is a temporary tablespace.
• B. Undo tablespace has only one datafile
• C. Undotablespace has a datafile which is reused in cyclic manner

Correct answer: A

Explanation

The correct answer is A because the undo tablespace serves as a temporary storage area for undo data during transactions. Option B is incorrect as undo tablespaces can have multiple datafiles, and option C is incorrect since the datafiles in an undo tablespace are not reused in a cyclic manner, but instead are used to store undo information until it is no longer needed.