Oracle
1Z0-064 · Question #10
1Z0-064 Question #10: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-064 to reveal the answer and full explanation for question #10. The question stem and answer options stay visible for context.
Question
For your database some users complain about not being able to execute transactions. Upon investigation, you find that the problem is caused by some users performing long-running transactions that consume huge amounts of space in the UNDO tablespace. You want to control the usage of the UNDO tablespace only for these user sessions. How would you avoid the issue from repeating in future? (Choose the best answer.)
Options
- ACreate a profile for the users with the LOGICAL_READS_PER_SESSION and
- BCreate external roles to restrict the usage of the UNDO tablespace and assign them to the users.
- CSet the threshold for UNDO tablespace usage for the users.
- DImplement a Database Resource Manager plan by mapping the users to a resource consumer
Unlock 1Z0-064 to see the answer
You've previewed enough free 1Z0-064 questions. Unlock 1Z0-064 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.