Quiz Chapter 5 Database

A requirement to begin designing physical files and databases is:

Normalization relations Definitions of each attribute Technology descriptions

A method for handling missing data is to:

Substitute and estimate the missing data Track missing data with special reports Perform sensitivity testing

All of the following are common denormalization opportunities EXCEPT:

a one-to-many relationship

All of the following are valid datatypes in Oracle 11g EXCEPT:

boolean

Sensitivity testing involves:

checking to see if missing data will greatly impact results.

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

data integrity

A detailed coding scheme recognized by system software for representing organizational data is called a(n):

data type

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

default value

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

descriptions

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

efficient data processing

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

extent

A factor to consider when choosing a file organization is:

fast data retrieval, security, efficient storage

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

A file organization that uses hashing to map a key into a location in an index where there is a pointer to the actual data record matching the hash key is called a:

hash index table

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

hashed

Which type of file is easiest to update?

hashed

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

operating system

In which data model would a code table appear?

physical

A(n) ________ is a field of data used to locate a related field or record.

pointer

A ________ limits the set of permissible values a field may assume.

range control

Which type of file is most efficient with storage space?

sequential

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

tablespace

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

use a lot of storage space

A rule of thumb for choosing indexes is to:

Be careful indexing attributes that may be null Index each primary key of each table. Use an index when there is variety in attribute values.

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

hashing algorithm

Which of the following is an objective of selecting a data type?

improve data integrity

An index on columns from two or more tables that come from the same domain of values is called a:

join index

An integrity control supported by a DBMS is:

range control

________ ensures that a value of a field exists in another database table.

referential integrity

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

A key decision in the physical design process is:

selecting structures