Which three statements are true about wrapping? (Choose three.)
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.
|
Download Printable PDF. VALID exam to help you PASS. |
 |
ADE
Are you sure F is true? It is not possible to unwrap a wrapped code back as far as I know.
So aonly D and E are true…
D,E.F
ADE correct answers
Correction : ADE
If your input file contains syntactic errors, the PL/SQL Wrapper detects and reports them. However, the Wrapper cannot detect semantic errors because it does not resolve external references. That is done at compile time. So, only the PL/SQL compiler can detect semantic errors.
PL/SQL Wrapper
https://docs.oracle.com/cd/A57673_01/DOC/server/doc/PLS23/apd.htm
Some quotes from reference to easier find answers:
http://docs.oracle.com/cd/B28359_01/appdev.111/b28370/wrap.htm#BEHJJHAG
“Wrap only the body of a package or object type, not the specification.
This allows other developers to see the information they must use the package or type, but prevents them from seeing its implementation.
To change wrapped PL/SQL code, edit the original source file and then wrap it again.
Wrapping does not detect syntax or semantic errors.
Wrapping detects only tokenization errors (for example, runaway strings), not syntax or semantic errors (for example, nonexistent tables or views). Syntax or semantic errors are detected during PL/SQL compilation or when executing the output file in SQL*Plus.”