フリー問題

Oracle Database 19c: Performance Management and Tuning のフリー問題 20 / 20 問目

問題文

A developer asks which part of memory holds the working data of a sort that a dedicated server process is performing on behalf of one session. Which description is correct?

選択肢

  1. The area for the results because it holds the rows that the operation has produced so far and returns them to the client when the sort has finished.
  2. The private region of that server process which holds the data and the control information of the process and the working area of each cursor that it is executing.
  3. The buffer for the change records because it holds the intermediate results until the operation reaches a point where the results can be discarded.
  4. The shared region of the instance because it holds the blocks that the sort reads and the executable form of the statement that started the sort.

解答・解説を確認するには

正解と解説の確認、回答の記録には無料登録が必要です。登録すると演習モードでフリー問題に回答し、正誤と解説をその場で確認できます。