WHEN YOU USE THE RESOURCE MANAGER TO DEFINE AN UNDO POOL, WHAT HAPPENS

8. When you use the Resource Manager to define an undo pool, what happens? (Choose the best answer.) A. If a user exceeds their quota on the undo tablespace, their session will hang. B. If a user exceeds their quota on the undo tablespace, the statement running will be rolled back but the rest of the statement will remain intact. C. If a group fills its undo pool, all the group’s transactions will hang until one session commits, rolls back, or is terminated. D. The effect depends on whether RETENTION GUARANTEE is enabled for the undo tablespace.