YOUR UNDO TABLESPACE CONSISTS OF ONE DATAFILE ON ONE DISK, AND TRA...

14. Your undo tablespace consists of one datafile on one disk, and transactions

are failing for lack of undo space. The disk is full. You have enabled retention

guarantee. Any of the following options could solve the problem, but which

would cause downtime for your users? (Choose the best answer.)

A. Create another, larger, undo tablespace and use alter system set

undo_tablespace= . . . to switch to it.

B. Move the datafile to a disk with more space, and use alter database

resize datafile . . . to make it bigger.

C. Reduce the undo_retention setting with alter system set

undo_retention= . . . .

D. Disable retention guarantee with alter tablespace . . .

retention guarantee.