問題文
A function reads a configuration table and also reads a value that is set for each session, and the team marks it so that its results are cached. Which description of what that marking demands of the function is correct?
選択肢
- The result has to be fixed by the arguments together with the moment at which the call is made, and a row that another session committed lies outside both of those sources, so the function has to read the table through a cursor that is opened again for each call.
- The result has to be fixed by the input arguments together with the committed content of the tables that the function reads, and a value that belongs to the session lies outside both of those sources, so that value has to reach the function as an argument of the call.
- The result has to be fixed by the input arguments and by nothing else at all, and a table that the function reads lies outside that single source, so the rows that the function needs have to reach it through a collection that the package holds for the session.
- The result has to be fixed by the state of the session together with the arguments that the caller passes, and a table of the schema lies outside both of those sources, so the function has to be compiled again whenever the content of that table has changed.