Oracle
1Z0-062 · Question #246
1Z0-062 Question #246: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-062 to reveal the answer and full explanation for question #246. The question stem and answer options stay visible for context.
Managing Performance
Question
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 youachieve this?
Options
- ASpecify the maximum amount of quota a user can be allocated in the undo tablespace.
- BDecrease the number of Interested Transaction List (ITL) slots for the segments on which these
- CImplement a profile for these users.
- DImplement a Database Resource Manager plan.
Unlock 1Z0-062 to see the answer
You've previewed enough free 1Z0-062 questions. Unlock 1Z0-062 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#Database Resource Manager#undo tablespace#resource limits#DML control