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?