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.*