Chapter 11

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

A) Completeness

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

A) Consistency

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

A) Query

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.

A) data inconsistency.

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

A) data redundancy

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) real-time processing

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.

A) transaction-processing system.

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) when the data is simple and can be organized in one table

________ 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

B) Artificial intelligence

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

B) Cube

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

B) Data Warehouse

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

B) Default value

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

B) Exception

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

B) Integrity

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

B) Relational

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

B) Unstructered

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

B) Warehouse

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

B) a collection of all the data from an organization's databases

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

B) business intelligence system

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.

B) data mining

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

B) database name

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

B) multidimensional database

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

B) object-oriented database

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.

B) primary key.

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

B) select query

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

C) Normalization

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

C) Redundancy

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

C) clickstream data.

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

D) All of the above

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

D) Data staging

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

D) Long text

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

D) Mining the data

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

D) Natural language processing (NLP) system

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

D) affinity grouping

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

D) filter

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

D) normalization.

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

D) one-to-many

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

D) one-to-one relationship

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

D) relational algebra

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

D)Field

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

False

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

False

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

False

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

False

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

True