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 AnswersA: 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.
A
“side effect”, some explainantion?