Chapter 11

In a database, the term ________ is synonymous with a category of data. A)record B)table C)row D)field

Big data analytics is usually associated with ________ services. A) decision support B) data warehouse C) office support D) management information

You can set a ________, which is automatically displayed in a field unless the user enters something different. A) field type B) default value C) numeric check D) relation

A(n) ________ is a way of retrieving information from one or more tables that defines a particular subset of data. A) query B) validation rule C) field constraint D) enquiry

If a school keeps two lists, one for student registration and one for student financial information, both containing name and address information, this is an example of data ________. A) integrity B) completeness C) redundancy D) normalization

A data ________ is a large-scale collection of data that contains and organizes all of an organization's data in one place. A) storehouse B) warehouse C) mart D) chain

________ is used to ensure that data is organized most efficiently in a database. A) Validation B) Consistency checking C) Normalization D) Range checking

Siri, the personal assistant application on Apple's iPhone is an example of a ________. A) management information system (MIS) B) decision support system (DSS) C) database management system (DBMS) D) natural language processing (NLP) system

________ databases are the most commonly used electronic databases. A) Object-oriented B) Relational C) Multidimensional D) Flat-file

Management information systems (MIS) provide ________ reports, which show conditions that are unusual or need attention from users of the system. A) detail B) exception C) expert D) summary

________ is the branch of computer science that attempts to create computers that think like humans. A) Natural language processing B) Artificial intelligence C) Enterprise resource planning D) Expert systems

Data staging consists of all of the following steps, EXCEPT ________. A) extracting the data B) transforming the data C) storing the data in a warehouse D) mining the data

Data ________ means that the data contained in a database is accurate and reliable. A) efficiency B) integrity C) consistency D) redundancy

A ________ displays a subset of data from a table (or tables) based on the specified criteria. A) join query B) select query C) table query D) criteria query

A ________ check compares the values of data in two or more fields to see whether those values are reasonable. A) consistency B) numeric C) correctness D) range

Data in a multidimensional database is organized in a ________ format. A) linear B) cube C) modular D) cellular

In a Microsoft Access database, something like the Gettysburg Address would be stored in a(n) ________ field. A) short text B) text C) object D) long text

Nontraditional data in object-oriented databases such as audio clips, video clips, pictures, and very large documents are called ________ data. A) enterprise B) unstructured C) multidimensional D) structured

A(n) ________ check determines whether a required field such as LastName was filled in. A) completeness B) consistency C) alphabetic D) range

SQL uses ________ to extract records from a database by using English-like expressions that have variables and operations. A) primary keys B) Boolean algebra C) foreign keys D) relational algebra

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 more than one person needs to access the data C) when data needs to be organized into two or more tables D) all of the above

A customer information table linked to an orders table in a business database reflects which type of relationship? A) many-to-many B) one-to-one C) many-to-one D) one-to-many

A process to ensure that data in a database is organized most efficiently is called A) integration. B) data staging. C) centralization. D) normalization.

Which of the following is NOT considered metadata? A) field size B) database name C) data type D) field name

Data captured as users navigate through a website is called A) staged data. B) time-variant data. C) clickstream data. D) web-user data

The type of database that would be best to store and organize video clips and pictures is which of the following? A) multidimensional database B) object-oriented database C) relational database D) all of the above

Which of the following is used to create a temporary subset of data that matches certain criteria? A) request B) relationship C) query D) filter

Which of the following data-mining techniques is used to determine which data goes together? A) classification B) clustering C) visualization D) affinity grouping

Unnecessary duplication of data in a database is referred to as A) data redundancy. B) data inconsistency. C) validated data. D) normalized data.

Which of the following is a method of inputting data into a transaction-processing system while the transaction is taking place? A) real-time processing B) input processing C) batch processing D) all of the above

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

A query is used to extract a subset of data from a database. True False

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

Data warehouses capture data only from one time period. True False

A multidimensional database uses two dimensions in which to organize data. True False

Which best describes a data warehouse? A) a building that stores computer servers B) a collection of all the data from an organization's databases C) a database that organizes data from multiple organizations D) a software program that assists with file management

Extracting, transforming, and storing data are processes associated with which of the following? A) transaction processing B) online analytical processing C) data scrubbing D) data staging

The process by which great amounts of data are analyzed and investigated is known as A) online analytical processing. B) data mining. C) data staging. D) clustering.

A system that is designed to help keep track of everyday business activities is a(n) A) transaction-processing system. B) enterprise resource planning system. C) management information system. D) decision support system.

Which type of information system is used mainly by executive managers and gathers data from data warehouses and data marts? A) expert system B) business intelligence system C) voice management system D) decision support system

Two lists showing different values for the same data in different places of a database is an example of A) data inconsistency. B) data redundancy. C) data irregularity. D) data disparity.

Which of the following is a TRUE statement when considering using databases instead of lists? A) Data-entry errors can be minimized with databases. B) Data integrity can be ensured with a database. C) Data can be easily shared among users. D) all of the above

Which type of relationship should be used to connect a Password table to a User Account table? A) many-to-many relationship B) one-to-none relationship C) one-to-many relationship D) one-to-one relationship

Which type of database organizes data by measure and feature attributes? A) object-oriented database B) multidimensional database C) relational database D) all of the above

The field that has a unique entry for each record in a database table is called the A) logical key. B) primary key. C) master field. D) foreign key.