Exam 12: Databases and Database Management Systems

In a column database, column orientation allows for a higher level of data ____________________ because there are often many similar, if not identical, entries in a single column.

A(n) ____ is a small table consisting only of the primary key field and the location information for each record.

A(n) ____________________ script is a set of instructions written in a programming language and designed to accept data from and return data to a Web page visitor.

One of the simplest hashing algorithms involves dividing the primary key field by a particular ____.

Database developers are the people responsible for managing the databases within an organization. _________________________

If a field needs to store decimal places, the Long Integer field size can be used.

Many-to-many entity relationships exist when one entity can be related to more than one other entity, and those entities can be related to multiple entities of the same type as the original entity.

A database typically consists of interrelated tables that contain forms and reports.

Hashing procedures usually result in two or more records being assigned the same storage address, an event known as a collision.

Repairing or restoring data that has become corrupt, such as the result of a storage media error or a computer virus, is a database analysis activity.

A database that combines object and relational database technology can be referred to as an object-oriented database management system (OODBMS).

Upgrading the database software as needed and installing security patches as they become available is a database ____________________ activity.

Cloud databases allow Web pages to be static Web pages; that is, Web pages in which the appearance or content of the pages changes based on the user's input. _________________________

One emerging data security risk is the exploitation of known but unpatched vulnerabilities by hackers. _________________________

To protect against data loss due to disasters, some firms maintain a redundant copy of the database on a(n) mirrored ​drive , backing up the data at very frequent intervals to an off-site location. _________________________

DBMSs available for use on personal computers include ____ and Corel Paradox.

Continually evaluating and improving the security measures used with the database is a database ____ activity.

Explain the concepts of database entities and attributes.

Normalization is usually viewed as a multistep process, moving the table structures from first normal form (1NF) to usually fifth normal form (5NF).

With a(n) ____________________, the data is separated into several databases, each of which is stored on a different computer that may be in different physical locations from one another but that are connected via a network.