Module 6 Pre check

Which type of file is most efficient with storage space? Group of answer choices Sequential Hashed Indexed Clustered

Sequential

The storage format for each attribute from the logical data model is chosen to maximize ________ and minimize storage space. Group of answer choices query design programmer productivity data integrity data integration

data integrity

A form of denormalization where the same data are purposely stored in multiple places in the database is called: Group of answer choices data duplication. data replication. advanced placement. horizontal partitioning.

data replication

In most cases, the goal of ________ dominates the design process. Group of answer choices efficient data processing security quick pointer updates shorter design times

efficient data processing

A factor to consider when choosing a file organization is: Group of answer choices inefficient data retrieval. DDL. efficient storage. DML.

efficient storage

A file organization where files are not stored in any particular order is considered a: Group of answer choices hashed file organization. hash key. multi-indexed file organization. heap file organization.

heap file organization

A key decision in the physical design process is: Group of answer choices ignoring the size of the database. selecting structures. deciding on the monitor. deciding the e-r diagrams.

selecting structures

A method for handling missing data is to: Group of answer choices substitute with random numbers for the missing data. track missing data with special reports. perform insensitivity testing. delete the associated row.

track missing data with special reports

Database access frequencies are estimated from:

transaction volumes.

All of the following are objectives when selecting a data type EXCEPT: Group of answer choices represent all possible values. improve data integrity. support all data manipulations. use a lot of storage space.

use a lot of storage space