cis351 ch 5 quiz
extra space and update time
A disadvantage of partitioning is:
heap file organization
A file organization where files are not stored in any particular order is considered a:
selecting structures
A key decision in the physical design process is:
hashing algorithm
A(n) ________ is a routine that converts a primary key value into a relative record number.
use a lot of storage space
All of the following are objectives when selecting a data type EXCEPT:
char
An appropriate datatype for one wanting a fixed-length type for last name would include:
range control
An integrity control supported by a DBMS is:
hashed
In which type of file is multiple key retrieval not possible?
data integrity
The storage format for each attribute from the logical data model is chosen to maximize ________ and minimize storage space.
sequential
Which type of file is most efficient with storage space?
efficient storage
a factor to consider when choosing a file organization is:
hash index table
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:
clustering
a method to allow adjacent secondary memory space to contain rows from several table is called:
join index
an index on columns from two or more tables that come from the same domain of values is called:
unit
the smallest unit of application data recognized by system software is:
hashed
which type of file is easiest to update?