Oracle Database 12c: Installation and Administration — Question 203

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 quota 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?

Answer options

• 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.

Correct answer: D

Explanation

The correct answer is D, as the Database Resource Manager can manage resources and enforce limits on undo space for specific users while allowing them to perform queries. Option A is incorrect because simply specifying a quota does not enforce aborting transactions if exceeded. Option B does not address the issue of undo space limitation directly, and option C is incorrect since profiles do not manage resource limits in this context.