Exam 8: Physical Database Design and Database Infrastructure

Broad network access is a characteristic of cloud computing.

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

What are the most important security features for data management software?

A default value is the value that a field will always assume, regardless of what the user enters for an instance of that field.

A cloud computing approach in which the service consists of software solutions intended to address the needs of a noncompeting activity is called:

Denormalization almost always leads to more storage space for raw data.

A discrete unit of work that must be processed completely or not at all within a computer system is called a:

A hashing algorithm is a routine that converts a primary key value into a relative record address.

Controls incorporated into a data management system that restrict access to data are called authentication rules.

A cloud computing approach in which the service consists mainly of hardware and systems software resources is called:

An extent is a named portion of secondary memory allocated for the purpose of storing physical records.

Explain what a tablespace is and how it is used.

Three-factor authentication is most often implemented with a credit card.

Keeping the zip code with the city and state in a table is a typical form of denormalization.

A device to measure or detect fingerprints or signatures is called a(n) ________ device.

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

When would you use horizontal partitioning, and when would you use vertical partitioning?

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

The coding or scrambling of data so that humans cannot read them is called:

While views promote security by restricting user access to data, they are not adequate security measures because: