Question 1

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_LINE

Question 2

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_CURSOR

Question 3

When is it appropriate to use native dynamic SQL?

Accepted Answer

The answer of When is it appropriate to use native...

Question 4

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_INADDR

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

A)  PARSE 
B)  BIND_VARIABLE 
C)  CLOSE_CURSOR 
D)  EXECUTE

Question 9

____ is responsible for checking syntax.

Accepted Answer

A)  PARSE 
B)  OPEN_CURSOR 
C)  CLOSE_CURSOR 
D)  OPEN_PARSER

Question 10

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.

Question 11

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_PIPE

Question 12

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_ALTER

Question 13

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 14

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...

Question 15

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)  RSET

Question 16

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)  trigger

Question 17

____ 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)  Cursors

Question 18

Obfuscating or wrapping code refers to hiding source code.

Accepted Answer

A) True 
 B)False

Question 19

____ retrieves the data returned by a query.

Accepted Answer

A)  BIND_VARIABLE 
B)  FETCH_ROWS 
C)  COLUMN_VALUE 
D)  DEFINE_COLUMN

Question 20

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

Accepted Answer

A) True 
 B)False

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

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

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

When is it appropriate to use native dynamic SQL?

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

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

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

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

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

____ is responsible for checking syntax.

Which of the following is a command line utility that assists in 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.

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

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

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

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

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) ____.

____ 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.

Obfuscating or wrapping code refers to hiding source code.

____ retrieves the data returned by a query.

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