問題文
A reviewer sees three different clauses on three functions of one package and asks what each of them tells the compiler. Which description of those three clauses is correct?
選択肢
- One of them names the units that may call the function, one of them fixes the value that the function returns for the session, and one of them makes the function run as an independent transaction of its own.
- One of them asks that a parameter be passed by reference rather than by value, one of them asserts that the function returns predictable results and has no side effects, and one of them states that the function is safe to run in parallel.
- One of them asks that a parameter be copied on the way in and on the way out, one of them asserts that the function reads no table at all, and one of them states that the function has to run in a session of its own.
- One of them turns off the optimizer for the function, one of them turns on the warnings for it, and one of them stores the result of the function in the data dictionary for later calls.