Review Exercise 1/ PART 2

A file organization is a named portion of primary memory.

FALSE

A join index is a combination of two or more indexes.

FALSE

A key is a data structure used to determine the location of rows in a file that satisfy some condition.

FALSE

An extent is a named portion of secondary memory allocated for the purpose of storing physical records.

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

Horizontal partitioning is very different from creating a supertype/subtype relationship.

FALSE

Horizontal partitioning refers to the process of combining several smaller relations into a larger table.

FALSE

Indexes are most useful on small, clustered files.

FALSE

One method to handle missing values is to substitute an exact value.

FALSE

Reduced uptime is a disadvantage of partitioning.

FALSE

A hashing algorithm is a routine that converts a primary key value into a relative record number.

TRUE

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

A tablespace is a named set of disk storage elements in which physical files for the database tables may be stored.

TRUE

Clustering allows for adjacent secondary memory locations to contain rows from several tables.

TRUE

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

TRUE

Fast data retrieval is one factor to consider when choosing a file organization for a particular database file.

TRUE

Hash partitioning spreads data evenly across partitions independent of any partition key value.

TRUE

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

TRUE

Indexes are most useful for columns that frequently appear in WHERE clauses of SQL commands, either to qualify the rows to select or for linking.

TRUE

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

TRUE

Security is one advantage of partitioning.

TRUE

Sensitivity testing involves ignoring missing data unless knowing a value might significantly change results.

TRUE

Vertical partitioning means distributing the columns of a table into several separate physical records.

TRUE