Exam 11: Advanced Data Management

A(n)____ trap is a block of code,within the main block,that will execute if a coding error occurs that is not trapped by the compiler.

Oracle Database comes with a multitude of pre-prepared packages.

The CHAR datatype in SQL*Loader is different from the CHAR datatype in an Oracle 10g table.

____ allow(s)construction of properly scripted intra-dependant SQL command structures.

The ____________________ keyword causes an error to be returned from a block of code.

PL / SQL uses some (but not all)of the datatypes used in SQL.

When should you use an implicit cursor or an explicit cursor?

The JUMP statement allows branching from one part of a program to another,either up or down the code.

The SQL*Loader ____________________ file contains a mapping between input data and table structures into which data is to be loaded.

An advantage of Data Pump over the original Import and Export utilities is that Data Pump has metadata filters allowing inclusion and exclusion of specific metadata items.

A load filter in SQL Loader uses a DISCARD clause,which can be used to discard rows from the loading process,potentially placing discarded rows in the discard file and not loading them into target database tables.

A package consists of a definitional section and a(n)____________________ section.

____ is a term given to a PL / SQL procedure or block of code that is not named,and is not stored in the database.

Every SQL statement issued stores its resulting state into a(n)____________________.

Data Pump (import and export)and ____ are used to perform bulk loads and dumps into and out of an Oracle database.

Direct path loads using SQL*Loader allow appending to tables.

The original Export utility is called ____.

The Data Pump import utility is called ____.

In a(n)____ path load rows are parsed into an array structure according to field specification,as defined by SQL Loader and the table to be added to;then,all elements in the array are processed by a bulk SQL INSERT command,passing through the SQL engine,and being added to a table as any INSERT statement would do.

A ____ is like a procedure except it allows a return value and can thus be embedded in an expression.