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.