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.