Exam 64: Database Structure

The iTunes library is based on database technology.

In a database,a collection of related fields that describes some object or activity is referred to as a ____.

____ is a concern for some organizations and individuals when data is collected in databases without their permission.

In a database,a collection of related records is referred to as a table or a ____.

A common type of flat file database format known as ____ stores records as a line of text separated by commas.

Increased data redundancy is one of the primary advantages of using a database.

Microsoft Outlook and Quicken are examples of ____ DBMSs that are used to store and manipulate personal data.

Big data is a term used to refer to data sets that are too large to process through traditional means.

Relationships between tables can be illustrated through a(n)____ relationship diagram.

To avoid data ____,a database stores data in one place.

____ involves combining two or more tables.

The most popular format for flat file databases is comma-separated values (CSV).

Database structure refers to the manner in which data is organized and stored.

Data ____ refers to the quality and accuracy of the data.

A terabyte is equal to 1 billion bytes.

A primary key is always made up of only one field.

Primary keys ensure that ____.

Data integrity refers to the quality and accuracy of the data.

A ____ is a collection of data that has been organized and made available to a user.

The ability to connect data in different tables through a common field is sometimes referred to as a relationship.