Exam 10: Basic Data Management

The metadata of an external table is stored in the database.

The ____ statement lets you remove existing rows from tables.

External tables can have all DML statements executed against them.

The locking mode ____________________ prohibits changes and allows queries only.

There are three primary DML statements used to change data in an Oracle database.These statements are INSERT,UPDATE,and ____________________.

SQL Loader can often be even as much as thousands of times faster in bulk loading data into a database,in comparison to executing a multitude of individually coded INSERT statements.

In general a properly coded application is likely to contain many more ROLLBACK than COMMIT statements.

The ____________________ utility can be used to rapidly load entire data sets into tables.

A(n)____________________ statement is commonly known as an upsert in that rows already existing in the target table are updated by source table rows.

The ____ statement is used to add new rows to tables.

The locking mode ____ is similar to ROW SHARE,additionally prohibiting a SHARE lock on the table.

A(n)____________________ INSERT statement adds to a single table.

The INSERT,UPDATE,and DELETE statements change data in a database and are thus all DDL statements.

A ____ is the most basic storage unit for data in Oracle 10g.

The ____ statement creates a label.That label can be used later in a transaction as a point to roll back to.

The SQL Loader utility is often called SQL*Loader or SQL*Ldr.

Why can DDL statements not be rolled back?

A(n)____________________ contains data in a file outside the database,such as in a text file.

____________________ are two-dimensional storage structures comprised of rows and columns.

A transaction is completed on execution of a COMMIT or ____ statement,or a disconnection from a session.