IBM Exam Questions

What is the FLUSH PACKAGE CACHE statement used for?

What is the FLUSH PACKAGE CACHE statement used for?

A.
It saves dynamic SQL stored in the package cache to an external file.

B.
To remove all cached static SQL statements from the package cache.

C.
To remove all cached dynamic SQL statements from the package cache.

D.
It causes all SQL statements in the package cache that are currently in use to be recompiled.