Chapter 11
A query is used to extract a subset of data from a database.
true
when is it sufficient to use a list to organize data? a. when the data is simple and can be organized in one table b. when data needs to be organized into tow or more tables c. when more than one person needs to access the data d. all of the above
when the data is simple and can be organized in one table
which of the following data-mining techniques is used to determine which data goes together a. classification b. clustering c. affinity grouping d. visualization
affinity grouping
Data captured from websites as users navigate through a website is called? clickstream data staged data web-user data time-variant data
clickstream data
unnecessary duplication of data in a database is referred to as a. data inconsistency b. normalized data c. validated data d. data redundancy
data redundancy
Which of the following is NOT considered metadata? field size database name field name data type
database name
A field labeled PHONE that accepts data such as (610) 555-1212 would use the Number data type.
false
A multidimensional database uses two dimensions in which to organize data
false
A small slice of a data warehouse is called a data mine.
false
Data warehouses capture data from only one time period.
false
which of the following is used to create a temporary subset of data that matches certain criteria a. filter b. query c. request d. relationship
filter
a process to ensure that data in a database is organized most efficiently is called a. normalization b. data staging c. centralization d. integration
normalization
The type of data that would be best to store and organize video clips and pictures in which of the following a. multidimensional database b. relational database c. object-oriented database d. all of the above
object-oriented database
a customer information table linked to an orders table in a business database reflects which type of relationship a. one-to-one b. one-to-many c. many-to-many d. many-to-one
one-to-many
which of the following is a method of inputting data into a transaction-processing system while the transaction is taking place a. batch processing b. real-time processing c. input processing d. all of the above
real-time processing
