Exam 10: Basic Data Management

The single table INSERT statement is used to insert rows into a single table,some tables,or all of a group of tables.

______________________________ statements are used to change data structures such as tables.

Default settings for the SET TRANSACTION statement are READ WRITE and ISOLATION LEVEL READ COMMITTED.

The ____ parameter for the SET TRANSACTION forces all queries to see data as a snapshot at a single point in time regardless of any database changes after the start of execution of each query in a transaction.

Default settings for the LOCK TABLE statement are ROW SHARE and MODE WAIT.

In commercial parlance,a ____ is a business agreement or exchange,usually involving money changing hands.

When using the SET TRANSACTION statement ______________________________ parameter,DML statements within a transaction will fail immediately if a row lock held by another transaction is encountered.

A ____ INSERT statement adds to more than a single table using the same INSERT statement,on a conditional basis.

The locking mode ____ prohibits locking of an entire table exclusively,allowing full concurrent multiple user access,with no restrictions on viewing and changing data in the table.

Redo log entries are written before anything else in order to maintain database recoverability.

A(n)____________________ is used to create a reference to a file,which is stored externally to an Oracle database.

It is important for database administrators to understand how COMMIT and ROLLBACK statements function.

The non-conditional multiple-table INSERT statement is used to execute all INSERT statements for all rows selected by the subquery.

You could read data from the external table using a(n)____ statement.

The locking mode ____ locks a table (or an updatable view),disallowing locking of the table in SHARE mode,and prohibiting changes to the table.

The ____________________ statement permits control of a transaction as a whole from the first DML statement through to a transaction completion statement or event.

____ is used to merge data from a source table into a target table.

The locking mode ____________________ prohibits any changes to a locked table,permitting concurrent queries only.

The ____ utilities can easily dump and import data from one or more tables,even entire schemas or a full database,including both data in tables and the table structures themselves.

The UPDATE statement allows you to remove existing rows in a table.