When using a PL/SQL stored package, how is a side effect defined?

When using a PL/SQL stored package, how is a side effect defined?

When using a PL/SQL stored package, how is a side effect defined?

A.
changes only to database tables

B.
changes only to packaged public variables defined in a package body

C.
changes only to packaged public variables defined in a package specification

D.
changes to database tables or packaged public variables defined in a package body

E.
changes to database tables or packaged variables defined in a package specification

Explanation:
Side effects are defined as changes to the database tables or the public packaged variables.
Incorrect Answers

A: Side effects are not limited to changes to the database tables. They also include changes to public packaged variables.
B: Variables defined in the package body are not public. C: This option excludes changes to database tables. D: Database Tables and Public variables are not defined in a package body.



Leave a Reply 2

Your email address will not be published. Required fields are marked *


Leo Yu

Leo Yu

“side effect”, some explainantion?