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 exceed 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. Implement a Database Resource Manager plan
B. Implement a profile for these users
C. Decrease the number of Interested Transaction List (ITL) slots for the segments on which these users perform transactions
D. Specify the maximum amount of quota a user can be allocated in the undo tablespace
|
Download Printable PDF. VALID exam to help you PASS. |
 |