Chapter 11

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

transaction-processing system.

When is it sufficient to use a list to organize data? (1 point) when data needs to be organized into two or more tables when the data is simple and can be organized in one table when more than one person needs to access the data all of the above

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

Data ________ ensures that the data contained in a database is accurate and reliable. (1 point) efficiency redundancy integrity consistency

integrity

Nontraditional data such as audio clips, video clips, pictures, and very large documents are called ________ data. (1 point) enterprise unstructured structured multidimensional

unstructured

Which of the following is NOT a true statement when considering using databases instead of lists? (1 point) Data integrity can be ensured with a database. Data can be easily shared among users. Databases are easier to build and maintain than lists. Data-entry errors can be minimized with databases.

Databases are easier to build and maintain than lists.

________ involves taking data from your database and putting it into an electronic file in a format that another external application or database can recognize. (1 point) Importing Extracting Exporting Enhancing

Exporting

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

False

A small slice of a data warehouse is called a data mine. (1 point) True False

False

Data warehouses capture data from only one time period. (1 point) True False

False

________ databases are the most commonly used electronic databases. (1 point) Flat-file Multidimensional Object-oriented Relational

Relational

Which of the following is a likely primary key? (1 point) Last name Date of birth Student ID number First name

Student ID number

A query is used to extract a subset of data from a database. (1 point) True False

True

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

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

Which is a report generated by a management information system? (1 point) exception report detail report summary report all of the above

all of the above

Data ________ helps to ensure data integrity by maintaining information in only one place. (1 point) mapping centralization flexibility redundancy

centralization

Data captured from websites as users navigate through a website is called? (1 point) time-variant data web-user data staged data clickstream data

clickstream data

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

completeness

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

consistency

Data in a multidimensional database is organized in a ________ format. (1 point) linear cellular cube modular

cube

Two lists showing different values for the same data in different places of a database is an example of (1 point) data inconsistency. data redundancy. data disparity. data irregularity.

data inconsistency.

The process by which great amounts of data are analyzed and investigated is known as (1 point) online analytical processing. clustering. data mining. data staging.

data mining.

Big data analytics is usually associated with ________ services. (1 point) decision support management information office support data warehouse

data warehouse

You can set a ________, which is automatically displayed in a field unless the user enters something different. (1 point) relation default value numeric check field type

default value

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

exception

In a database, the term ________ is synonymous with a category of information. (1 point) record row table field

field

You would use a ________ to temporarily display records of residents of the city of Boston. (1 point) filter validation rule sieve field constraint

filter

Which of the following database systems uses artificial intelligence? (1 point) knowledge-based system transaction-processing system enterprise resource planning system office support system

knowledge-based system

Data staging consists of all of the following steps, EXCEPT ________. (1 point) extracting the data mining the data transforming the data storing the data in a warehouse

mining the data

The type of database that uses fields, records, and measure as data attributes is (1 point) multidimensional. object-oriented. two-dimensional. relational.

multidimensional.

The personal assistant application on Apple's iPhone is an example of a ________. (1 point) database management system (DBMS) management information system (MIS) natural language processing (NLP) system decision support system (DSS)

natural language processing (NLP) system

Siri, Cortana, and Google Now are examples of which type of knowledge-based system? (1 point) artificial intelligence natural language processing system voice management system expert system

natural language processing system

Which type of database would be best to handle unstructured data? (1 point) relational database multidimensional database object-oriented database all of the above

object-oriented database

Which type of relationship should be used to connect a Password table to a User Account table? (1 point) one-to-none relationship one-to-one relationship one-to-many relationship many-to-many relationship

one-to-one relationship

The field that has a unique entry for each record in a database table is called the (1 point) logical key. primary key. foreign key. master field.

primary key.

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

query

In a transaction-processing system (TPS), if the TPS database can be queried and updated while the transaction is taking place, this is called ________ processing. (1 point) batch direct real-time immediate

real-time

Which is NOT a component of a database that describes how data is stored? (1 point) report record table field

report

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

select query

Which of the following is NOT considered metadata? (1 point) table name field size the data type field name

table name

________ is the branch of computer science that attempts to create computers that think like humans. (1 point) Expert systems Artificial intelligence Natural language processing Enterprise resource planning

Artificial intelligence