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

____ allows us to make the SQL statements in our PL/SQL code much more flexible in regards to providing values, such as column names, at runtime.

TheOPEN FOR method cannot reuse parsed statements. _________________________

One advantage of LOBs is that a table can have multiple LOB columns but only one LONG column.

The ____ package provides access to DDL statements that cannot be included directly within PL/SQL code.

Dynamic SQL allows us to employ a more object-oriented approach to modeling our database and applications.

Attempting to use a(n) _________________________ to provide an identifier, such as a column name or table name, in an SQL statement within PL/SQL raises an error.

You must enable DBMS output in order to see the display from DBMS_OUTPUT commands.

The ____ built-in package retrieves Internet site host names or IP addresses.

The ____ built-in package is used to access Web pages.

Dynamic SQL allows the criteria of a query such as the column checked in the WHERE clause to be identified at compile time.

Attempting to use a parameter to provide an identifier, such as a column name or table name, in an SQL statement within PL/SQL raises an error.

The BLOB, CLOB, and NCLOB objects can all be stored internally and are typically stored in a separate tablespace from database tables to enable optimization of the attributes of each tablespace for the type of data being stored.

The _________________________ method of the ANALYZE_OBJECT procedure in the DBMS_DDL package erases the statistics that already exist in the data dictionary for an object.

The use of a(n) _________________________ statement, such as ALTER TABLE or CREATE TABLE, directly within PL/SQL produces an error.

An EXECUTE step is not needed with DDL statements because the PARSE step automatically executes the statement upon successful parsing.

The goal of SQL is to empower users with little or no query skills to be able to perform a variety of data queries.

DBMS_SQL is simpler to code and processes more efficiently than native dynamic SQL.

All of the following programs are available in the UTL_FILE package, except ____.

The ____ method can be used to implement native dynamic SQL.

The ability to send e-mails from within PL/SQL code has been simplified with the introduction of the DBMS_ALERT package.