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