問題文
A long load is run inside a session for which the waiting behavior has been turned on, and a reviewer asks which failures make a statement wait rather than end. Which statement about the conditions that lead to a wait is correct?
選択肢
- Running out of room in the tablespace, reaching the number of extents that the object was declared with, and going past the room allowance of the account are the three that lead to a wait, so a failure of any other sort still ends the statement.
- Reaching the number of extents that the object was declared with is the one that leads to a wait, so running out of room in the tablespace and going past the room allowance of the account both end the statement at once instead.
- Running out of room in the tablespace, losing the lock that another session had taken, and going past the room allowance of the account are the three that lead to a wait, so a failure of any other sort still ends the statement at once.
- Running out of room in the tablespace is the one that leads to a wait, so going past the room allowance of the account and reaching the number of extents that the object was declared with both end the statement once it comes.