You want to prevent a group of users in your database from performing long-running transactions that consume huge amounts of space in the undo tablespace. If the guota for these users is exceeded during execution of a data manipulation language (DML) statement, the operation should abort and return an error. However, queries should still be allowed, even if users have exceeded the undo space limitation.
How would you achieve this?
A. Specify the maximum amount of quota a user can be allocated in the undo tablespace
B. Decrease the number of Interested Transaction List (ITL) slots for the segments on which these users perform transactions
C. Implement a profile for these users.
D. Implement a Database Resource Manager plan