Chapter 11; Facts

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

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

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

all of the above

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

artificial intelligence

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

centralization

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

clickstream data

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

consistency

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

data inconsistency

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

data mining

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

data warehouse

A ________ is a group of related data that can be stored, sorted, organized, and queried. database macro memo spreadsheet

database

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

databases are easier to build and maintain than lists

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

default value

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

exporting

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

false

T/F A small slice of a data warehouse is called a data mine

false

T/F Data warehouses capture data from only one time period.

false

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

field

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

filter

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

integrity

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

knowledge-based system

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

multidimensional

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

natural language processing (NLP) system

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

natural language processing system

Which type of database would be best to handle unstructured data? object-oriented database relational database multidimensional 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? many-to-many relationship one-to-many relationship one-to-none relationship one-to-one relationship

one-to-one relationship

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

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 enquiry field constraint query

query

A ________ check would be used to restrict the fines for speeding violations from $50 to $250. consistency numeric range completeness

range

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 ________. normalization completeness redundancy integrity

redundancy

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

relational

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

relational algebra

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

report

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

select query

In a database, a group of related records is referred to as a(n) ________. object memo table field

table

Which of the following is NOT considered metadata? field name the data type field size table name

table name

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

transaction-processing system

T/F A query is used to extract a subset of data from a database.

true

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

unstructured

A data ________ is a large-scale electronic repository of data that contains and organizes all of an organization's data in one place. chain mart storehouse warehouse

warehouse

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

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