Oracle
1Z0-064 · Question #51
Examine the query and its output: Which two statements are true? (Choose two.)
The correct answer is B. Session 4208 is either idle or experiencing poor response time due to a network or resource D. Session 3346 is in wait state because either it is waiting to update a row that is locked by another. See the full explanation below for the reasoning.
Question
Examine the query and its output:
Which two statements are true? (Choose two.)
Exhibit
Options
- ASession 2832 had to wait 2029 seconds for a message to arrive because of a network bottleneck.
- BSession 4208 is either idle or experiencing poor response time due to a network or resource
- CSession 3346 is in wait state because it wants to lock a row in a block in which other sessions
- DSession 3346 is in wait state because either it is waiting to update a row that is locked by another
- ESession 4208 is definitely idle and should be killed to free network resources.
How the community answered
(14 responses)- A14% (2)
- B79% (11)
- E7% (1)
Community Discussion
No community discussion yet for this question.