Chapter 6 Quiz and Practice Quiz

Which of the following is software that handles all application operations between browser-based computers and a company's back-end business applications or databases? A) Database server software B) Application server software C) Web browser software D) Data mining software E) Web server software

B) Application server software

Which of the following is a specialized language that programmers use to add and change data in the database? A) Data access language B) Data manipulation language C) DBMS D) Data definition language E) Structured query language

B) Data manipulation language

________ creates confusion that hampers the creation of information systems that integrate data from different sources. A) Batch processing B) Data redundancy C) Data independence D) Online processing E) Data quality

B) Data redundancy

Which of the following is a grouping of characters into a word, a group of words, or a complete number? A) File B) Field C) Tuple D) Entity E) Table

B) Field

________ tools are used to analyze large unstructured data sets, such as email, memos, and survey responses to discover patterns and relationships. A) OLAP B) Text mining C) In-memory D) Clustering E) Classification

B) Text mining

Data mining allows users to: A) obtain online answers to ad-hoc questions in a rapid amount of time. B) find hidden relationships in data. C) access the vast amounts of data in a data warehouse. D) quickly compare transaction data gathered over many years. E) summarize massive amounts of data into much smaller, traditional reports.

B) find hidden relationships in data.

Data ________ occurs when the same data is duplicated in multiple files of a database. A) partitions B) redundancy C) repetition D) discrepancy E) independence

B) redundancy

A household appliances manufacturer has hired you to help analyze its social media datasets to determine which of its refrigerators are seen as the most reliable. Which of the following tools would you use to analyze this data? A) Data governance software B) Text mining tools C) Sentiment analysis software D) Web mining technologies E) Data mining software

C) Sentiment analysis software

In data mining, which of the following involves events linked over time? A) Associations B) Classifications C) Sequences D) Clustering E) Forecasting

C) Sequences

Data cleansing not only corrects errors but also: A) establishes logical relationships between data. B) removes duplicate data. C) enforces consistency among different sets of data. D) structures data. E) normalizes data.

C) enforces consistency among different sets of data.

A schematic of the entire database that describes the relationships in a database is called a(n): A) intersection relationship diagram. B) data analysis table. C) entity-relationship diagram. D) data dictionary. E) data definition diagram.

C) entity-relationship diagram.

A database ________ describes a database entity. A) file B) value C) record D) byte E) field

C) record

Microsoft SQL Server is a(n): A) DBMS for both desktops and mobile devices. B) Internet DBMS. C) desktop relational DBMS. D) DBMS for midrange computers. E) DBMS for mobile devices.

D) DBMS for midrange computers.

Which of the following is an automated or manual file that stores information about data elements and data characteristics such as usage, physical representation, ownership, authorization, and security? A) Entity-relationship diagram B) Relationship dictionary C) Data definition diagram D) Data dictionary E) Data table

D) Data dictionary

An organization's rules for sharing, disseminating, acquiring, standardizing, classifying, and inventorying information is called a(n): A) data quality audit. B) data definition file. C) data policy. D) information policy. E) data governance policy.

D) information policy.

Which of the following enables you to create a script that allows a web server to communicate with a back-end database? A) CGI B) HTML C) Java D) SQL E) NoSQL

A) CGI

Which of the following is a DBMS for desktop computers? A) Microsoft Access B) Microsoft Exchange C) Oracle Database D) Microsoft SQL Server E) DB2

A) Microsoft Access

Microsoft Access's data dictionary displays all of the following information about a field except the: A) the organization within the organization that is responsible for maintaining the data. B) description of the field. C) size of the field. D) format of the field. E) type of the field.

A) the organization within the organization that is responsible for maintaining the data.

A(n) ________ represent data as two-dimensional tables. A) non-relational DBMS B) relational DBMS C) object-oriented DBMS D) mobile DBMS E) hierarchical DBMS

B) relational DBMS

In a table for customers, the information about a single customer resides in a single: A) field. B) row. C) column. D) table. E) entity.

B) row.

In a large organization, which of the following functions would be responsible for policies and procedures for managing internal data resources? A) Database management B) Information policy administration C) Data administration D) Database administration E) Data auditing

C) Data administration

You work for a retail clothing chain whose primary outlets are in shopping malls and are conducting an analysis of your customers and their preferences. You wish to find out if there are any particular activities that your customers engage in, or the types of purchases made in the month before or after purchasing select items from your store. To do this, you will want to use the data mining software you are using to do which of the following? A) Identify associations B) Identify clusters C) Identify sequences D) Classify data E) Create a forecast

C) Identify sequences

MongoDB and SimpleDB are both examples of: A) open source databases. B) SQL databases. C) NoSQL databases. D) cloud databases. E) big data databases.

C) NoSQL databases.

A characteristic or quality that describes a particular database entity is called a(n): A) relationship. B) key field. C) tuple. D) field. E) attribute.

E) attribute.

DBMSs typically include report generating tools in order to: A) retrieve and display data. B) analyze the database's performance. C) perform predictive analysis. D) display data in graphs. E) display data in a more structured and polished format than would be possible just by querying.

E) display data in a more structured and polished format than would be possible just by querying.

Multiple data marts are combined and streamlined to create a data warehouse. True or False?

False

A physical view shows data as it is actually organized and structured on the data storage media. True or False?

True

Complicated groupings of data in a relational database need to be adjusted to eliminate awkward many-to-many relationships. True or False?

True

High-speed analytic platforms use both relational and non-relational tools to analyze large datasets. True or False?

True

Legacy systems are used to populate and update data warehouses. True or False?

True

Middleware is an application that transfers information from an organization's internal database to a web server for delivery to a user as part of a web page. True or False?

True

Spanner is an example of a distributed database. True or False?

True

You can use OLAP to perform multidimensional data analysis. True or False?

True