Concepts Chapter 8 Database Quiz

Primary keys ensure that ____.

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

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

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

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

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

In a database, first name would be an example of a ____.

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

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

One of the first steps in creating a database is to build queries and reports that can pull information from the data that is stored.

When a database problem occurs, its tables may be split up during the ____ process to correct a data problem.

A data definition language is used to define the ____ of a database.

A popular database software program called ____ offers a wizard and QBE tool to help build and generate SQL queries.

A database ____ is a graphical representation of the structure of a database.

The ____ data manipulation language is used to build databases in both mainframe and personal computers.

Inaccurate input entered into a database resulting in incorrect output is also known as ____.

On Amazon.com, when the customer is ready to make a purchase, the database ____ manages the entire process.

A data center is used by large organizations to store older archived data that is no longer needed on a day-to-day basis.

Installation and the ongoing maintenance of software in a database system are the job of the database ____.

Data mining is used to generate business intelligence.

As data centers continue to grow in size to multi-acre facilities, the number of employees required to run them also grows proportionally.

Industrial databases are large databases that function as the cornerstone of information systems in businesses and enterprises.

Which of the following tasks is the typically a primary responsibility of a database administrator?

A data center that is run and managed in an automated fashion while being monitored remotely is referred to as a ____ environment.

The iTunes library is based on database technology.

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

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

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

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

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

Data integrity refers to the quality of data: the degree to which it is accurate and up to date.

A database schema can stand alone as a single file or be part of a database.

A data dictionary provides a detailed description of each field and table in a database.

A schema illustrates the ____ and ____ in a database and the relationships among them.

One of the first steps in creating a database is to build queries and reports that can pull information from the data that is stored.

A data mine is a climate-controlled building or set of buildings that house servers that store and deliver mission-critical information and services.

Distributed databases connect data at different locations using ____ networks.

With ____, users are able to store data on Internet servers housed in data centers.

A distributed database is also known as a ____ database.

A replicated database is a database that holds a duplicate set of frequently used data.

A very large database that holds important data from a variety of sources is called a ____.

A data mine is a large database that holds information to analyze pricing trends.

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

In a relational database, a ____ would ensure that two customers with the same name don't get confused with each other.

A(n) ____ database organizes data into multiple tables that are related by common fields.

In 1986, the American National Standards Institute (ANSI) adopted ____ as the standard query language for relational databases.

Inaccurate input entered into a database resulting in incorrect output is also known as ____.

The process of extracting information from a data warehouse or data mart is called ____.

A ____ is a skilled and trained computer professional who directs all activities related to an organization's database.

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

Online services such as Google and Amazon rely on data organized by databases.

A primary key is a ____ within a database table that uniquely identifies each record.

The data manipulation language ____ is a popular tool when querying a relational database.

SQL is one example of a data manipulation language.

Database tools include software and techniques for analyzing, maintaining, and manipulating data in a database.

The output of data mining in a business setting is sometimes called ____.