Exam 11: Advanced Data Management

PL / SQL is a restricted form of SQL.

Before using export or import utilities you can go into a shell and bring up the help screen for the utility by typing utilname ____.

A block of code is a self-contained sequence of one or more commands.

Data Pump has an interactive command mode allows monitoring of ongoing ____________________.

Exporting and importing is allowed at all logical layers such as export of individual tables,entire schemas,groups of objects,or even an entire database.

Database exports can be used to migrate and upgrade between different versions of Oracle Database.

SQLERR is a built-in procedure that returns an error message,determined by the value of SQLCODE.

If using SQL*Plus and not SQL*Plus Worksheet,you should not forget the ____ character on the last line as the code block will not execute without it.

An automatic cursor is declared automatically by PL / SQL.

SQL*Loader is not limited to individual table loads.

A PL / SQL ____________________ is a composite structure similar to a VARRAY or TABLE datatype that allows the creation of a table row structure in memory.

The ____ statement has both search condition and selector-expression variations.

SQL Loader allows loading of operating system ____ files into one or more tables at once.

A(n)____________________ cursor is a by reference cursor.

What is the difference between a function and a procedure?

PL / SQL sequencing controls include the GOTO command and the ____ statement.

A(n)____ path load writes data to the end of a table into new block and extent structures,creating new blocks as it goes.

Generally the old import and export utilities are secure because users have to have the schema ____________________ names to access schemas.

The LOOP...END loop continues as long as a condition holds true.

A conventional path load is potentially much faster than direct path loads.