321- Chapter 6

A field identified in a table as holding the unique identifier of the table's records is called the: A) primary key. B) key field. C) primary field. D) foreign key. E) identifying field

a

Data mining is a tool for allowing users to: A) find hidden relationships in data. B) quickly compare transaction data gathered over many years. C) obtain online answers to ad hoc questions in a rapid amount of time. D) summarize massive amounts of data into much smaller, traditional reports. E) perform multidimensional data analysis

a

The process of streamlining data to minimize redundancy and awkward many‐to‐many relationships is called: A) normalization. B) data scrubbing. C) data cleansing. D) data administration. E) data management

a

A characteristic or quality describing an entity is called a(n): A) field. B) attribute. C) key field. D) tuple. E) table

b

A schematic of the entire database that describes the relationships in a database is called a(n): A) data dictionary. B) entity‐relationship diagram. C) Intersection relationship diagram. D) field key diagram. E) data definition diagram

b

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

b

Tools for consolidating, analyzing, and providing access to vast amounts of data to help users make better business decisions are known as: A) DSS. B) business intelligence. C) OLAP. D) data mining. E) in‐memory computing

b

Which of the following best describes the importance of creating an accurate data model for your business's database? A) it is not essential, as the data model itself is modified by the database continuously. B) it is critical, as without one, your data may be inaccurate, incomplete, or difficult to retrieve. C) it is essential, as table relationships cannot be created without an accurate data model. D) it is somewhat important, as the type of data model will define what kinds of data will be stored. E) it is unnecessary, as a well‐designed database should not require one.

b

A database that stores current and historical data of potential interest to decision makers throughout a company is called A) huge data B) MYSQL C) data warehouse D) data stash E) data granary

c

Detecting and correcting data in a database or file that are incorrect, incomplete, improperly formatted, or redundant is called: A) data auditing. B) defragmentation C) data scrubbing D) data optimization E) data repair

c

In terms of the data relationships found by data mining, associations refers to: A) events linked over time. B)patterns that describe a group to which an item belongs. C) occurrences linked to a single event. D) undiscovered groupings. E) classification when no groups have yet been defined

c

The confusion created by ________ makes it difficult for companies to create customer relationship management, supply chain management, or enterprise systems that integrate data from different sources. A) batch processing B) online processing C) data redundancy D) data independence E) data freedom

c

Access is a: A) DBMS for mobile devices. B) popular open‐source DBMS. C) DBMS for midrange computers. D) DBMS for desktop PC systems. E) DBMS for mainframe computers.

d

What are the relationships that the relational database is named for? A) Relationships between rows and columns B) Relationships between fields and records C) Relationships between databases D) Relationships between entities E) Relationships between attributes

d

Which of the following database types would be best suited for storing multimedia? A) SQL DBMS B) Open‐source DBMS C) Cloud‐based database D) Non‐relational DBMS E) NoSQL DBMS.

d

Hadoop is a(n): A) NoSQL database technology that stores both data and procedures acting on the data as objects. B) data mining platform designed for storing and analyzing big data produced by web communications and transactions. C) pre‐configured hardware‐software system designed for analyzing big data. D) high‐speed platform used to analyze large data sets. E) open‐source software framework designed for distributing data‐processing over inexpensive computers.

e

OLAP is a tool for enabling users to: A) view both logical and physical views of data. B) quickly diagram data relationships. C) normalize data. D) find hidden patterns in large databases E)obtain online answers to ad hoc questions in a rapid amount of time

e

Relational database systems use ________ to ensure that relationships between coupled tables remain consistent. A) intersection relations B) entity‐relationship diagrams C) one‐to‐one ordering D) foreign keys E) referential integrity rules

e