試題詳解

QUESTION 87 When using a packaged function in a query, what is true? 中間 2行短
(A) The COMMIT and ROLLBACK commands are allowed in the packaged function.
(B) You can not use packaged functions in a query statement.
(C) The packaged function cannot execute an INSERT, UPDATE, or DELETE statement against the table that is being queried.
(D) The packaged function can execute and INSERT, UPDATE, or DELETE statement against the table that is being queried if it is used in a subquery.
(E) The packaged function can execute an INSERT, UPDATEM or DELETE statement against the table that is being queried if the pragma RESTRICT REFERENCE is used.