Which two statements are true?

Examine the query and its output:

Which two statements are true? (Choose two.)

Examine the query and its output:

Which two statements are true? (Choose two.)

A.
Session 2832 had to wait 2029 seconds for a message to arrive because of a network bottleneck.

B.
Session 4208 is either idle or experiencing poor response time due to a network or resource bottleneck on
the client process.

C.
Session 3346 is in wait state because it wants to lock a row in a block in which other sessions have already
locked rows, and there is no free ITL slot available in this block.

D.
Session 3346 is in wait state because either it is waiting to update a row that is locked by another session or
another session is trying to insert the same key value in a UNIQUE index.

E.
Session 4208 is definitely idle and should be killed to free network resources.



Leave a Reply 0

Your email address will not be published. Required fields are marked *