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 changea 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.
Explanation:
http://docs.oracle.com/cd/B28359_01/appdev.111/b28370/wrap.htm#BEHJJHAG
A,D,E
D, E, F
A) false, BUT it WAS true in old versions of oracle
-Wrapping does not detect syntax or semantic errors
http://docs.oracle.com/cd/E18283_01/appdev.112/e17126/wrap.htm#BEHGBJAA
B) false, because of point A
C) false, because if to wrap specification we can’t use these packages/types
http://docs.oracle.com/cd/E18283_01/appdev.112/e17126/wrap.htm#BEHJJHAG
D) true, because of point C
E) true, see link http://docs.oracle.com/cd/B28359_01/appdev.111/b28370/wrap.htm#LNPLS016
F) true, http://docs.oracle.com/cd/E18283_01/appdev.112/e17126/wrap.htm#BEHGBJAA
Wrapping is not a secure method for hiding passwords or table names.
Wrapping a PL/SQL unit helps prevent most users from examining the source code, but might not stop all of them.
D E
D, E, F
To be sure in F visit the link: http://www.codecrete.net/UnwrapIt/
D E F THEN
SORRY
A,D,E
d e f
F is incorrect see my comments below.
DEF
DEF
A,D,E
Can’t say if it’s ADE or DEF.
It’s true, with some tool you can unwrap wrapped files. It’s either true, Oracle doesn’t recognize any unwrap tool. In Oracle the wrapped can’t be unwrapped.
It’s true, the A was true in early version, so I supposed that this question is enough old to make me choose ADE instead of DEF.
I choose A,D,E.
answer-A,D,E
for A-plsql 11g part 2,les_11.ppt pg-28
A,D,E
————-
“A” and “B”: Let’s skip these options for a while.
“C” is obvious incorrect.
“D” and “E” are correct options.
“F”: This option is illegitimate. Oracle don’t offer any tool to unwrap code.
https://asktom.oracle.com/pls/apex/f?p=100:11:::NO:RP:P11_QUESTION_ID:65664128910452
“A” and “B”: Since Oracle 11g wrapping tool detects only tokenization errors, not syntax or semantic errors.
But in documentation for Oracle 10g we can read: “If your PL/SQL compilation units contain syntax errors, the wrap utility detects and reports them. The wrap utility does not detect semantic errors”.
So, I would choose option “A” because we must choose three.
i’m answer DEF and lost my exam(
oracle write me that i must learn:
Hide PL/SQL source code using dynamic obfuscation and the Wrap utility
i think A D E is good
Wrapping does not detect syntax or semantic errors.
Wrap only the body of a package or ADT, not the specification.
To change wrapped PL/SQL code,
edit the original source file and then wrap it again.
Wrapping is not a secure method for hiding passwords or table names.
Oracle 10g : “If your PL/SQL compilation units contain syntax errors, the wrap utility detects and reports them. The wrap utility does not detect semantic errors”.
So A is correct
Surprised so many have DEF as answers. E and F are contradictory. So answer can either be E or F as long as the english is correct. Anyway answer is ADE
Sorry just D and E
paul
question say’s choose three
so how come is D,E
D,E are correct. Not sure what to select for 3rd one.
I was thinking A is correct but documentation says only tokenization errors
(Both the PL/SQL Wrapper utility and DBMS_DDL subprograms detect tokenization errors (for example, runaway strings), but not syntax or semantic errors (for example, nonexistent tables or views).)
for option E
http://docs.oracle.com/cd/E11882_01/appdev.112/e25519/wrap.htm#LNPLS1743
read “PL/SQL Source Text Wrapping Guidelines” section
A, D, and E are correct.
F is incorrect.
see below:
https://asktom.oracle.com/pls/apex/f?p=100:11:::YES:RP:P11_QUESTION_ID:65664128910452
ADE
ADE It is
A: https://docs.oracle.com/cd/A97630_01/appdev.920/a96624/c_wrap.htm
D: It is a Standard Practice so that, Application developer will know what the Package Contains
E: https://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:65664128910452
A,D,E from ORACLE user guide.
https://docs.oracle.com/cd/A97630_01/appdev.920/a96624/c_wrap.htm
Correct answer: A D, E:
Justification (From Oracle Documentation):
————-
Guidelines include the following:
• When wrapping a package or object type, wrap only the body, not the specification.
Thus, you give other developers the information that they need to use the package
without exposing its implementation.
• 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. For example, the wrapper does not report an error if the table or
view amp does not exist:
CREATE PROCEDURE raise_salary (emp_id INTEGER, amount NUMBER) AS
BEGIN
UPDATE amp — should be emp
SET sal = sal + amount WHERE empno = emp_id;
END;
However, the PL/SQL compiler resolves external references. Therefore, semantic errors
are reported when the wrapper output file (.plb file) is compiled.
• Because its contents are not readable, the output file should not be edited. To change a
wrapped object, you need to modify the original source code and wrap the code again.
this exam is for 11G, r1 and r2? or r1 only, i think all version, so most actually is r2.
anyway…in 11G (both) only 2 answer are correct.
D,E ARE CORRECT.
A IS SURE INCORRECT IN 11G r1, http://docs.oracle.com/cd/B28359_01/appdev.111/b28370/wrap.htm#BEHGBJAA
A IS INCORRECT IN 11G r2, documentation said: Both the PL/SQL Wrapper utility and DBMS_DDL subprograms detect tokenization errors (for example, runaway strings), but not syntax or semantic errors (for example, nonexistent tables or views). https://docs.oracle.com/cd/E11882_01/appdev.112/e25519/wrap.htm#LNPLS1744
F: SURE INCORRECT, there are not anyway to unwrapp, only way is wrap the origianl sql again.
maybe choose 3 answer is an error
this exam is for 11G, r1 and r2? or r1 only, i think all version, so most actually is r2.
anyway…in 11G (both) only 2 answer are correct.
D,E ARE CORRECT.
A IS SURE INCORRECT IN 11G r1, http://docs.oracle.com/cd/B28359_01/appdev.111/b28370/wrap.htm#BEHGBJAA
A IS INCORRECT IN 11G r2, documentation said: Both the PL/SQL Wrapper utility and DBMS_DDL subprograms detect tokenization errors (for example, runaway strings), but not syntax or semantic errors (for example, nonexistent tables or views). https://docs.oracle.com/cd/E11882_01/appdev.112/e25519/wrap.htm#LNPLS1744
F: SURE INCORRECT, there are not anyway to unwrapp, only way is wrap the origianl sql again.
maybe choose 3 answer is an error.
no way only D,E CORRECT.
this exam is for 11G, r1 and r2? or r1 only, i think all version, so most actually is r2.
anyway…in 11G (both) only 2 answer are correct.
D,E ARE CORRECT.
A IS SURE INCORRECT IN 11G r1, http://docs.oracle.com/cd/B28359_01/appdev.111/b28370/wrap.htm#BEHGBJAA
A IS INCORRECT IN 11G r2, documentation said: Both the PL/SQL Wrapper utility and DBMS_DDL subprograms detect tokenization errors (for example, runaway strings), but not syntax or semantic errors (for example, nonexistent tables or views). https://docs.oracle.com/cd/E11882_01/appdev.112/e25519/wrap.htm#LNPLS1744
F: SURE INCORRECT, there are not anyway to unwrapp, only way is wrap the origianl sql again.
maybe choose 3 answer is an error
this exam is for 11G, r1 and r2? or r1 only, i think all version, so most actually is r2.
anyway…in 11G (both) only 2 answer are correct.
D,E ARE CORRECT.
A IS SURE INCORRECT IN 11G r1
A IS INCORRECT IN 11G r2, documentation said: Both the PL/SQL Wrapper utility and DBMS_DDL subprograms detect tokenization errors (for example, runaway strings), but not syntax or semantic errors (for example, nonexistent tables or views).
F: SURE INCORRECT, there are not anyway to unwrapp, only way is wrap the origianl sql again.
maybe choose 3 answer is an error.
no way only D,E CORRECT.
A,D,E
Guidelines for Wrapping
———————————————
When wrapping a package or object type, wrap only the body, not the specification. Thus, you give other developers the information they need to use the package without exposing its implementation.
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. For example, the wrapper does not report an error if the table or view amp does not exist:
CREATE PROCEDURE raise_salary (emp_id INTEGER, amount NUMBER) AS
BEGIN
UPDATE amp — should be emp
SET sal = sal + amount WHERE empno = emp_id;
END;
However, the PL/SQL compiler resolves external references. Therefore, semantic errors are reported when the wrapper output file (.plb file) is compiled.
The output file should not be edited, because its contents are not readable. To change a wrapped object, you need to modify the original source code and wrap the code again.
ADE
ade
This is the best search engine in the planet
http://google.com