Exam 11: Advanced Data Management

The original Import utility is called ____.

The ____ utility is generally the most efficient tool for the mass loading of data into an Oracle database.

What is an associative array?

Associative arrays are currently only allowed in PL / SQL and not Oracle SQL.

A(n)____ is executed based on an event occurring in the database.

In their current form Data Pump utilities are for ____________________-level users only.

The Data Pump export utility is called ____.

Add a WHEN OTHERS exception trap to the following code:

The LOOP...END construct can be used as a(n)____________________ loop (iterates until a condition is true)by placing an EXIT WHEN clause just before the END LOOP statement.