Oracle
1Z0-034 · Question #35
1Z0-034 Question #35: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-034 to reveal the answer and full explanation for question #35. The question stem and answer options stay visible for context.
Question
The database users regularly complain about the difficulty in performing transactions. On investigation, you find that some users perform long-running transactions that consume huge amounts of space in the undo tablespace, which caused the problem. You want to control the usage of the undo tablespace only for these user sessions and you do not want these sessions to perform long-running operations. How would you achieve this?
Options
- AImplement a profile for the users.
- BImplement external roles for the users.
- CSet the threshold for the undo tablespace.
- DImplement a Database Resource Manager plan.
Unlock 1Z0-034 to see the answer
You've previewed enough free 1Z0-034 questions. Unlock 1Z0-034 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.