Chapter 11

Which of the following is not considered metadata?

Database name

A field labeled PHONE that accepts data such as (610) 555-1212 would use the Number data type.

False

A small slice of a data warehouse is called a data mine.

False

Data warehouses capture data only from one time period.

False

Which type of database is best for handling unstructured types of data such as audio and video files?

Object-oriented

A customer information table linked to a password table in a business database reflects which type of relationship?

One-to-one

Which of the following is used to create a subset of data that matches certain criteria and that can be saved for future reference or use?

Query

Which of the following is a method of inputting data into a transaction-processing system while the transaction is taking place?

Real-time processing

A primary key is used to identify records uniquely.

True

ETL refers to extract, transform, and load

True

NoSQL databases are best used with what type of data?

Unstructured, dynamic, web-based data

Which of the following data-mining techniques is used to create charts and dashboards?

Visualization

When is a flat database sufficient to use when organizing data?

When the data is simple and can be organized in one table

Data captured as users navigate through a website is called

clickstream data.

Unnecessary duplication of data in a database is referred to as

data redundancy.