問題文
A query has to show a computed value beside each row, and a batch has to receive two computed values in variables. Which pair of forms fits those two needs?
選択肢
- A function for the query, and a function for the batch, because a function can return a record with two fields and a query can name it in the select list while the batch reads the two fields of the value that it returns.
- A procedure for the query, and a procedure for the batch, because a procedure that writes its results into a table lets the query read them with a join afterwards.
- A procedure with two parameters that return values for the query and a function for the batch, because a query can name such a procedure in its select list and read both of the values from it.
- A function for the query, and a procedure with two parameters that return values for the batch that has to receive the two computed numbers of its own.