Chapter 5 Quiz
Which of the following is an objective of selecting a data type?
Improve data integrity
A file organization that uses hashing to map a key into a location in an index where there is a pointer to the actual data record matching the hash key is called a:
hash index table.
An appropriate datatype for adding a sound clip would be:
Blob
An appropriate datatype for one wanting a fixed-length type for last name would include:
Char
Which type of file is most efficient with storage space?
Sequential
________ partitioning distributes the columns of a table into several separate physical records.
Vertical
All of the following are common denormalization opportunities EXCEPT:
a one-to-many relationship.
A form of denormalization where the same data are purposely stored in multiple places in the database is called:
data replication
Designing physical files requires ________ of where and when data are used in various ways.
descriptions
A contiguous section of disk storage space is called a(n):
extent
A disadvantage of partitioning is:
extra space and update time.
The smallest unit of application data recognized by system software is a:
field
A(n) ________ is a routine that converts a primary key value into a relative record number.
hashing algorithm
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(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
Database access frequencies are estimated from:
transaction volumes.
All of the following are objectives when selecting a data type EXCEPT:
use a lot of storage space.
Horizontal partitioning makes sense:
when different categories of a table's rows are processed separately.