Question 1

Which of the following is a command line utility that assists in hiding source code?

Accepted Answer

A)   wrap utility.
B)   obfuscate utility.
C)   DBMS_DDL utility.
D)   wrapcode utility.E) A) and D)
F) B) and C)

Question 2

The init.ora file contains all the settings for the database and is read when the database is started up.

Accepted Answer

A) True 
 B)False

Question 3

____ retrieves the data returned by a query.

Accepted Answer

A)   BIND_VARIABLE
B)   FETCH_ROWS
C)   COLUMN_VALUE
D)   DEFINE_COLUMNE) A) and B)
F) A) and C)

Question 4

BEGIN
DBMS_OUTPUT.PUT('This') ;
DBMS_OUTPUT.PUT(' is a') ;
DBMS_OUTPUT.PUT(' test') ;
DBMS_OUTPUT.PUT_LINE('This is test2') ;
DBMS_OUTPUT.PUT('Working?') ;
END;
The code fragment above is an example of a(n)  ____.

Accepted Answer

A)   cursor
B)   alert
C)   anonymous block
D)   triggerE) B) and D)
F) All of the above

Question 5

____ are used to distinguish parameter values that are used as criteria in the DBMS_SQL package, versus parameters that provide identifiers such as column names.

Accepted Answer

A)   DDLs
B)   Placeholders
C)   DMLs
D)   CursorsE) A) and B)
F) A) and C)

Question 6

____ is responsible for checking syntax.

Accepted Answer

A)   PARSE
B)   OPEN_CURSOR
C)   CLOSE_CURSOR
D)   OPEN_PARSERE) All of the above
F) B) and C)

Question 7

Obfuscating or wrapping code refers to hiding source code.

Accepted Answer

A) True 
 B)False

Question 8

The ____ package can be used to analyze the HTML source of Web sites in order to accomplish tasks such as tracking competitor pricing on products, gathering pricing for raw materials, and collecting relevant business news for a particular industry.

Accepted Answer

A)   UTL_HTTP
B)   UTL-SMTP
C)   DBMS_ALERT
D)   DBMS_PIPEE) B) and D)
F) A) and B)

Question 9

Native dynamic SQL is simpler to code and processes statements more efficiently than the DBMS_SQL package. _________________________

Accepted Answer

A) True 
 B)False

Question 10

When is it appropriate to use native dynamic SQL?

Accepted Answer

It is appropriate to use native dynamic ...

Question 11

The ____ procedure of the DBMS_DDL package allows developers to programmatically compile database objects.

Accepted Answer

A)   ALTER_RECOMPILE
B)   ANALYZE_OBJECT
C)   ALTER_COMPILE
D)   DDL_ALTERE) C) and D)
F) B) and D)

Question 12

The DBMS_DDL package provides the only Oracle method available to hide source code.

Accepted Answer

A) True 
 B)False

Question 13

The REQUEST_PIECES function is typically used to avoid possibly truncating information contained on the Web page.

Accepted Answer

A) True 
 B)False

Question 14

The ____ built-in package contains a miscellaneous group of programs ranging from capabilities to assist in procedure management to reporting error information.

Accepted Answer

A)   DBMS_SESSION
B)   DBMS_UTILITY
C)   DBMS_XMLGEN
D)   UTL_INADDRE) C) and D)
F) B) and D)

Question 15

A(n) mutator is similar to a partition or area of the physical disk. _________________________

Accepted Answer

A) True 
 B)False

Question 16

The ____ program associates placeholders in the Cursor with PL/SQL variables.

Accepted Answer

A)   PARSE
B)   BIND_VARIABLE
C)   CLOSE_CURSOR
D)   EXECUTEE) B) and D)
F) A) and B)

Question 17

The DBMS_OUTPUT procedure ____ places an end-of-line marker in the buffer.

Accepted Answer

A)   ENABLE
B)   PUT_LINE
C)   NEW_LINE
D)   GET_LINEE) None of the above
F) All of the above

Question 18

In the UTL_HTTP package, the ____ function is used to retrieve the HTML source from a specified URL.

Accepted Answer

A)   REQUEST_PIECES
B)   NOOP
C)   RCPT
D)   RSETE) B) and D)
F) B) and C)

Question 19

All of the following, except ____, represent steps required to perform DDL with the DBMS_SQL package.

Accepted Answer

A)   OPEN_CURSOR
B)   PARSE
C)   BIND_VARIABLE
D)   CLOSE_CURSORE) None of the above
F) C) and D)

Question 20

The _________________________ package was introduced with Oracle version 7 to allow more dynamic SQL code within PL/SQL coding.

Accepted Answer

The answer of The _________________________ package was introduced with Oracle...

Exam 10: Oracle-Supplied Packages, Dynamic SQL, and Hiding Source Code

The ____ package can be used to analyze the HTML source of Web sites in order to accomplish tasks such as tracking competitor pricing on products, gathering pricing for raw materials, and collecting relevant business news for a particular industry.

Correct AnswerverifiedShow Answer

The init.ora file contains all the settings for the database and is read when the database is started up.

Correct AnswerverifiedShow Answer

The ____ program associates placeholders in the Cursor with PL/SQL variables.

Correct AnswerverifiedShow Answer

A(n) mutator is similar to a partition or area of the physical disk. _________________________

Correct AnswerverifiedShow Answer

The DBMS_OUTPUT procedure ____ places an end-of-line marker in the buffer.

Correct AnswerverifiedShow Answer

____ are used to distinguish parameter values that are used as criteria in the DBMS_SQL package, versus parameters that provide identifiers such as column names.

Correct AnswerverifiedShow Answer

The ____ built-in package contains a miscellaneous group of programs ranging from capabilities to assist in procedure management to reporting error information.

Correct AnswerverifiedShow Answer

All of the following, except ____, represent steps required to perform DDL with the DBMS_SQL package.

Correct AnswerverifiedShow Answer

____ is responsible for checking syntax.

Correct AnswerverifiedShow Answer

In the UTL_HTTP package, the ____ function is used to retrieve the HTML source from a specified URL.

Correct AnswerverifiedShow Answer

The ____ procedure of the DBMS_DDL package allows developers to programmatically compile database objects.

Correct AnswerverifiedShow Answer

The REQUEST_PIECES function is typically used to avoid possibly truncating information contained on the Web page.

Correct AnswerverifiedShow Answer

The DBMS_DDL package provides the only Oracle method available to hide source code.

Correct AnswerverifiedShow Answer

The _________________________ package was introduced with Oracle version 7 to allow more dynamic SQL code within PL/SQL coding.

Correct AnswerverifiedShow Answer

Obfuscating or wrapping code refers to hiding source code.

Correct AnswerverifiedShow Answer

____ retrieves the data returned by a query.

Correct AnswerverifiedShow Answer

Which of the following is a command line utility that assists in hiding source code?

Correct AnswerverifiedShow Answer

Native dynamic SQL is simpler to code and processes statements more efficiently than the DBMS_SQL package. _________________________

Correct AnswerverifiedShow Answer

BEGIN DBMS_OUTPUT.PUT('This') ; DBMS_OUTPUT.PUT(' is a') ; DBMS_OUTPUT.PUT(' test') ; DBMS_OUTPUT.PUT_LINE('This is test2') ; DBMS_OUTPUT.PUT('Working?') ; END; The code fragment above is an example of a(n) ____.

Correct AnswerverifiedShow Answer

When is it appropriate to use native dynamic SQL?

Correct AnswerverifiedIt is appropriate to use native dynamic ...View AnswerShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
It is appropriate to use native dynamic ...
View Answer