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

The UTL_LINE package allows access to files that reside on an operating system and are accessible from the database server. _________________________

In which of the following situations is the use of native dynamic SQL considered inappropriate?

The ____ package allows access to two DDL statements that cannot be used directly within a PL/SQL block: ALTER_COMPILE and ANALYZE_OBJECT.

The array-like processing available in DBMS_SQL makes working with many rows much more cumbersome.

The _________________________ action of the DBMS_DDL package computes statistics on a database object, typically tables and indexes, such as the range of values.

The code fragment ____ would raise an error.

DBMS_DDL.ALTER_COMPILE ( Type VARCHAR2, Schema VARCHAR2, Name VARCHAR2); In the header for the ALTER_COMPILE procedure above, the ____ statement refers to the object's owner.

In the DBMS_LOB package, the term ____ represents programs that read LOBs or information about the LOBs.

When executing a stored program, any DBMS_OUTPUT lines are placed in an output buffer, which dumps its contents to the screen when the program has completed execution. _________________________

The util.ora file contains environment settings, such as the UTL_FILE_DIR parameter, that determine if and how certain Oracle features are accessible from within PL/SQL code.

In the DBMS_DDL package, ____ is a valid ANALYZE_OBJECT exception.

All of the following procedures are included in the DBMS_ALERT package, except ____.

What is the goal of dynamic SQL?

The ____ built-in package retrieves information about database objects.

Which of the following is the correct syntax for an EXECUTE IMMEDIATE statement?

____ establishes a work area for a statement to be handled.

The UTL_HTTP package provides the capability to make Hypertext Transfer Protocol (HTTP) calls from within PL/SQL programs. _________________________

Describe the basic mechanics of the alert process.

A(n) _________________________ is a pointer to a cursor or SQL work area.

The basic mechanics of the alert process include registering an alert name, setting up when an alert should signal, and enabling the appropriate users to receive the alert.