Exam 11: Advanced Data Management

PL / SQL stands for _________________________ SQL.

The usability of ____ technology is in question because it is only available to database- and operating-system level administrative personnel.

An advantage of Data Pump over the original Import and Export utilities is its better handling of bulk loading and unloading,allowing complete restart or a temporary halt

What is the difference between a by value parameter and a by reference parameter?

A sequencing control is allowed to disrupt the logical flow of a program through its lines of code.

A(n)____ path load is a variation on a direct path load and is potentially faster than a direct path load.

A ____ is a block of code that allows by value and by reference parameters with no return value.

The idea of the export and import utility is to allow a copy from a database of a complete set of data and its ____________________.

The simplest block of code you can create in PL / SQL is a block,enclosed between BEGIN and END commands,containing the command ____________________.

The ____________________ keyword is required in PL / SQL in to copy unique values retrieved by a SELECT statement into program variables.

You can invoke SQL*Loader from a shell using the ____________________ command.

A(n)____________________ block of code is stored and can be recalled later and re-executed again,without having to retype the entire block of code.

By reference (BYREF)implies that a variable is a pointer and can be passed into,but not out of,a procedure within procedure parameters.

A disadvantage of Data Pump over the original Import and Export utilities is that the latter provide better network support.

Oracle requires a single quote to apply a(n)____________________ to the second,ignoring the quote as a string terminator.

The ____________________ loop iterates through a known set of values.

The PL / SQL ____________________ datatype stores a TRUE,FALSE or null value.

Indirect path loads are very important to performance as they allow much faster performance during imports,by to the ends of datafiles,without having to pass through the SQL engine.

A cursor ____________________ is an implicit cursor on the basis that it does not require use of the OPEN,FETCH,and CLOSE statements.

In PL / SQL a block is a chunk of code containing both PL / SQL and ____________________ commands.