MGT 4058 Chapter 5

Which type of file is easiest to update?

*A. Hashed* B. Sequential C. Clustered D. Indexed

Sensitivity testing involves:

*A. checking to see if missing data will greatly impact results.* B. checking to see if your teeth hurt when you brush. C. deleting the associated row. D. seeing how accurate data are.

A form of denormalization where the same data are purposely stored in multiple places in the database is called:

*A. data replication.* B. advanced placement. C. data duplication. D. horizontal partitioning.

In most cases, the goal of ________ dominates the design process.

*A. efficient data processing* B. quick pointer updates C. security D. shorter design times

A requirement to begin designing physical files and databases is:

*A. normalized relations.* B. physical tables created. C. implementation complete. D. all datatypes determined.

Which type of file is most efficient with storage space?

A. Clustered B. Indexed C. Hashed *D. Sequential*

In which data model would a code table appear?

A. Data layout B. Logical *C. Conceptual* D. Physical

The smallest unit of application data recognized by system software is a:

A. column. *B. field.* C. row. D. data type.

A method to allow adjacent secondary memory space to contain rows from several tables is called:

A. concatenating. *B. clustering.* C. cluttering. D. compiling.

A method for handling missing data is to:

A. delete the associated row. B. perform insensitivity testing. C. substitute with random numbers for the missing data. *D. track missing data with special reports.*

A key decision in the physical design process is:

A. ignoring the size of the database. B. deciding the e-r diagrams. C. deciding on the monitor. *D. selecting structures.*

A(n) ________ is a routine that converts a primary key value into a relative record number.

A. index pointer program *B. hashing algorithm* C. record index calculator D. pointing algorithm

Designing physical files requires ________ of where and when data are used in various ways.

A. keys B. hints *C. descriptions* D. maps

Distributing the rows of data into separate files is called:

A. normalization. B. file allocation. C. vertical partitioning. *D. horizontal partitioning.*

The storage format for each attribute from the logical data model is chosen to maximize ________ and minimize storage space.

A. query design B. programmer productivity *C. data integrity* D. data integration

Database access frequencies are estimated from:

A. random number generation. B. security violations. C. user logins. *D. transaction volumes.*

The value a field will assume unless the user enters an explicit value for an instance of that field is called a:

A. range control. B. null value. *C. default value.* D. gurand.

All of the following are objectives when selecting a data type *EXCEPT*:

A. represent all possible values. B. support all data manipulations. C. improve data integrity. *D. use a lot of storage space.*

A contiguous section of disk storage space is called a(n):

A. sector. B. tablespace. *C. extent.* D. track.

Horizontal partitioning makes sense:

A. when only one category is allowed. B. when partitions must be organized the same. C. when less security is needed. *D. when different categories of a table's rows are processed separately.*