Oracle
1Z0-062 · Question #312
1Z0-062 Question #312: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-062 to reveal the answer and full explanation for question #312. The question stem and answer options stay visible for context.
Managing Data and Concurrency
Question
Examine the parameters: Users complain that their sessions for certain transactions hang. You investigate and discover that some users fail to complete their transactions, causing other transactions to wait on row-level locks. Which two actions would you take to prevent this problem? (Choose two.)
Exhibit
Options
- AIncrease the maximum number of ITL slots for segments on which a blocking user performs a
- BDecrease the SESSIONS_PER_USER limit in the profiles assigned to blocking users.
- CSet a limit in the profiles of blocking users to control the number of data blocks that can be accessed in a
- DUse Database Resource Manager to automatically kill the sessions that are idle and are blocking other
- EDecrease the IDLE_TIME resource limit in the profiles assigned to blocking users.
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
#locking contention#profiles#resource limits#transaction management