Oracle
1Z0-054 · Question #126
As part of the performance-tuning activity, you executed the utllockt.sql script. What does this script do? (Choose all that apply.)
The correct answer is C. displays information about the sessions that are waiting for locks D. displays information about the locks for which sessions are waiting. See the full explanation below for the reasoning.
Question
As part of the performance-tuning activity, you executed the utllockt.sql script. What does this script do? (Choose all that apply.)
Options
- Apopulates the v$locked_object view
- Bcreates the dba_locks and dba_blockers views
- Cdisplays information about the sessions that are waiting for locks
- Ddisplays information about the locks for which sessions are waiting
How the community answered
(42 responses)- A14% (6)
- B7% (3)
- C79% (33)
Community Discussion
No community discussion yet for this question.