Oracle Database 11g: Program with PL/SQL — Question 9

Which three statements are true about wrapping? (Choose three.)

Answer options

• A. The PL/SQL wrapper detects and reports only syntax errors.
• B. The PL/SQL wrapper detects and reports both syntax and semantic errors.
• C. When wrapping a package or object type, both the body and specification should be wrapped.
• D. When wrapping a package or object type, only the body should be wrapped, not the specification.
• E. To change a wrapped object, the original source code needs to be modified and then wrapped again.
• F. To change a wrapped object, the wrapped code can be unwrapped, modified in a text file, and then wrapped again.

Correct answer: D, E, F

Explanation

The correct answer is D, E, F because when wrapping a package or object type, only the body is necessary to wrap as stated in D. Modifications can only be made to the original source code or through unwrapping, which is reflected in E and F. Options A and B are incorrect because they misrepresent the capabilities of the PL/SQL wrapper regarding error detection.