CSC 350 Quiz 5

One method to handle missing values is to substitute an exact value.

FALSE

In which type of file is multiple key retrieval not possible?

Hashed

In which data model would a code table appear?

Physical

A pointer is a field of data that can be used to locate a related field or record of data.

TRUE

Denormalization almost always leads to more storage space for raw data

TRUE

One decision in the physical design process is selecting structures.

TRUE

Requirements for response time, data security, backup and recovery are all requirements for physical design.

TRUE

Sensitivity testing involves ignoring missing data unless knowing a value might significantly change results.

TRUE

A method for handling missing data is to: A) substitute and estimate for the missing data. B) track missing data with special reports. C) perform sensitivity testing. D) all of the above.

all of the above.

A rule of thumb for choosing indexes is to: A) be careful indexing attributes that may be null. B) index each primary key of each table. C) use an index when there is variety in attribute values. D) all of the above.

all of the above.

Sensitivity testing involves:

checking to see if missing data will greatly impact results.

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

default value.

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

field

A(n) ________ is a technique for physically arranging the records of a file on secondary storage devices.

file organization

While Oracle has responsibility for managing data inside a tablespace, the tablespace as a whole is managed by the:

operating system.

One field or combination of fields for which more than one record may have the same combination of values is called a(n):

secondary key.

Within Oracle, the named set of storage elements in which physical files for database tables may be stored is called a(n):

tablespace.