DRM chap5

extent

A contiguous section of disk storage space is called a(n): Question options: A) extent. B) sector. C) tablespace. D) track.

extra space and update time.

A disadvantage of partitioning is: Question options: A) extra space and update time. B) remote optimization. C) shorter technology spans. D) simplicity.

hash index table.

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: Question options: A) hash key. B) hashed file organization. C) multi-indexed file organization. D) hash index table.

data replication.

A form of denormalization where the same data are purposely stored in multiple places in the database is called: Question options: A) horizontal partitioning. B) data replication. C) data duplication. D) advanced placement.

normalized relations.

A requirement to begin designing physical files and databases is: Question options: A) all datatypes determined. B) implementation complete. C) normalized relations. D) physical tables created.

pointer

A(n) ________ is a field of data used to locate a related field or record. Question options: A) key B) pointer C) index D) lock

hashing algorithm

A(n) ________ is a routine that converts a primary key value into a relative record number. Question options: A) record index calculator B) pointing algorithm C) hashing algorithm D) index pointer program

a one-to-many relationship.

All of the following are common denormalization opportunities EXCEPT: Question options: A) a one-to-many relationship. B) two entities with a one-to-one relationship. C) reference data. D) a many-to-many relationship with nonkey attributes.

use a lot of storage space.

All of the following are objectives when selecting a data type EXCEPT: Question options: A) support all data manipulations. B) use a lot of storage space. C) improve data integrity. D) represent all possible values.

Blob

An appropriate datatype for adding a sound clip would be: Question options: A) VarChar. B) Char. C) Blob. D) Date

Char.

An appropriate datatype for one wanting a fixed-length type for last name would include: Question options: A) Blob. B) VarChar. C) Date. D) Char.

join index.

An index on columns from two or more tables that come from the same domain of values is called a: Question options: A) bitmap index. B) multivalued index. C) transaction index. D) join index.

transaction volumes

Database access frequencies are estimated from: Question options: A) random number generation. B) user logins. C) security violations. D) transaction volumes.

descriptions

Designing physical files requires ________ of where and when data are used in various ways. Question options: A) descriptions B) maps C) keys D) hints

when different categories of a table's rows are processed separately.

Horizontal partitioning makes sense: Question options: A) when different categories of a table's rows are processed separately. B) when less security is needed. C) when only one category is allowed. D) when partitions must be organized the same.

secondary key.

One field or combination of fields for which more than one record may have the same combination of values is called a(n): Question options: A) index. B) secondary key. C) composite key. D) linked key.

field

The smallest unit of application data recognized by system software is a: Question options: A) field. B) column. C) row. D) data type.

Improve data integrity

Which of the following is an objective of selecting a data type? Question options: A) Represent a small number of possible values B) Improve data integrity C) Maximize storage space D) Limit security

Sequential

Which type of file is most efficient with storage space? Question options: A) Clustered B) Sequential C) Indexed D) Hashed

Vertical

________ partitioning distributes the columns of a table into several separate physical records. Question options: A) Horizontal B) Final C) Crossways D) Vertical