MGT 4058 Chapter 5 – Flashcards
Unlock all answers in this set
Unlock answersquestion
A key decision in the physical design process is:
answer
A. ignoring the size of the database. B. deciding the e-r diagrams. C. deciding on the monitor. *D. selecting structures.*
question
Which type of file is most efficient with storage space?
answer
A. Clustered B. Indexed C. Hashed *D. Sequential*
question
A method for handling missing data is to:
answer
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.*
question
A method to allow adjacent secondary memory space to contain rows from several tables is called:
answer
A. concatenating. *B. clustering.* C. cluttering. D. compiling.
question
A(n) ________ is a routine that converts a primary key value into a relative record number.
answer
A. index pointer program *B. hashing algorithm* C. record index calculator D. pointing algorithm
question
A requirement to begin designing physical files and databases is:
answer
*A. normalized relations.* B. physical tables created. C. implementation complete. D. all datatypes determined.
question
All of the following are objectives when selecting a data type *EXCEPT*:
answer
A. represent all possible values. B. support all data manipulations. C. improve data integrity. *D. use a lot of storage space.*
question
The smallest unit of application data recognized by system software is a:
answer
A. column. *B. field.* C. row. D. data type.
question
Designing physical files requires ________ of where and when data are used in various ways.
answer
A. keys B. hints *C. descriptions* D. maps
question
Which type of file is easiest to update?
answer
*A. Hashed* B. Sequential C. Clustered D. Indexed
question
A contiguous section of disk storage space is called a(n):
answer
A. sector. B. tablespace. *C. extent.* D. track.
question
Distributing the rows of data into separate files is called:
answer
A. normalization. B. file allocation. C. vertical partitioning. *D. horizontal partitioning.*
question
Horizontal partitioning makes sense:
answer
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.*
question
Database access frequencies are estimated from:
answer
A. random number generation. B. security violations. C. user logins. *D. transaction volumes.*
question
The value a field will assume unless the user enters an explicit value for an instance of that field is called a:
answer
A. range control. B. null value. *C. default value.* D. gurand.
question
A form of denormalization where the same data are purposely stored in multiple places in the database is called:
answer
*A. data replication.* B. advanced placement. C. data duplication. D. horizontal partitioning.
question
In most cases, the goal of ________ dominates the design process.
answer
*A. efficient data processing* B. quick pointer updates C. security D. shorter design times
question
The storage format for each attribute from the logical data model is chosen to maximize ________ and minimize storage space.
answer
A. query design B. programmer productivity *C. data integrity* D. data integration
question
In which data model would a code table appear?
answer
A. Data layout B. Logical *C. Conceptual* D. Physical
question
Sensitivity testing involves:
answer
*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.
