Exam 7: Basic Table Management

After a table is defined,you can use SQL to add data to the table.

What are temporary tables?

In Oracle 10g release 2 (10.2)each database has its own Database Control service running on a Windows computer (selected when creating the database using the ________________________________________ tool.)

A(n)____________________ is a query that is embedded in another SQL command.

The ____ runs on a database server through an HTTP protocol and could have security issues.

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

The ____ datatype stores unstructured data in binary format.

Temporary tables use temporary segments in either a temporary tablespace or a permanent tablespace.

All full table scans by queries read the entire table,including any deleted extents,ultimately leading to poor performance.

Index-organized tables cannot be partitioned.

Tables can be partitioned to store large quantities of data and increase performance of access to that data.

A(n)____________________ alias is a short name for a results column and is used when generating tables or views to give the results column a valid column name.

Locally managed tables eliminate much of the work in managing storage space.

A(n)____ table is a table where the primary key contains both the index and the data (non-indexed columns in the table).

An object table is ____ when you insert records into the table.

Oracle 10g allows the physical splitting of table data into separated sections called ____.

____ tables contain data in a file outside the database,such as in a text file.

To prevent row migration,you can adjust two storage parameters to suit the characteristics of your table's data: PCTFREE and ____.

Tablespace parameters cannot be overridden by setting them when you create a table.

You should use a(n)____________________ table when the data is retrieved by primary key values or ranges of primary key values.