CS 4420 Intro to Database Systems Final Chapter 5

An appropriate datatype for adding a sound clip would be:

Blob

A file organization is a named portion of primary memory.

False

Adding notations to the EER diagram regarding data volumes and usage is of no value to the physical design process.

False

Denormalization is the process of transforming relations with variable-length fields into those with fixed-length fields.

False

Free range partitioning is a type of horizontal partitioning in which each partition is defined by a range of values for one or more columns in the normalized table.

False

The Number datatype would be appropriate for a zip code.

False

The smallest unit of application data recognized by system software is a:

Field

Which type of file is most efficient with storage space?

Sequential

A pointer is a field of data that can be used to locate a related field or record of data.

True

A range control limits the set of permissible values that a field may assume.

True

Denormalization almost always leads to more storage space for raw data.

True

Efficient database structures will be beneficial only if queries and the underlying database management system are tuned to properly use the structures.

True

In a sequential file, the records are stored in sequence according to a primary key value.

True

Keeping the zip code with the city and state in a table is a typical form of denormalization.

True

One objective of selecting a data type is to minimize storage space.

True

Security is one advantage of partitioning.

True

All of the following are valid datatypes in Oracle 11g EXCEPT:

boolean

An advantage of partitioning is:

efficiency

A factor to consider when choosing a file organization is:

efficient storage.

A contiguous section of disk storage space is called a(n):

extent

A disadvantage of partitioning is:

extra space and update time.

A(n) ________ is a routine that converts a primary key value into a relative record number.

hashing algorithm

A file organization where files are not stored in any particular order is considered a:

heap file organization.

An index on columns from two or more tables that come from the same domain of values is called a:

join index.

A requirement to begin designing physical files and databases is:

normalized relations.

A method that speeds query processing by running a query at the same time against several partitions of a table using multiprocessors is called:

parallel query processing.

A(n) ________ is a field of data used to locate a related field or record.

pointer

One field or combination of fields for which more than one record may have the same combination of values is called a(n):

secondary key.

A method for handling missing data is to:

track missing data with special reports.

Database access frequencies are estimated from:

transaction volumes.