FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 6: Foundations of Business Intelligence: Databases and Information Management

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 31

Multiple Choice

Review LaterAdd Note

Review Later

The data dictionary serves as an important data management tool by

A) assigning attributes to the data.
B) creating an inventory of the data elements contained in the database.
C) presenting data as end users or business specialists would perceive them.
D) maintaining data in updated form.

Correct Answer

verified

Show Answer

Question 32

Multiple Choice

Review LaterAdd Note

Review Later

Which common database challenge is illustrated by a person receiving multiple copies of an L.L. Bean catalog, each addressed to a slightly different variation of his or her full name?

A) data normalization
B) data accuracy
C) data redundancy
D) data inconsistency

Correct Answer

verified

Show Answer

Question 33

Essay

Review LaterAdd Note

Identify and describe three basic operations used to extract useful sets of data from a relational database.

The disadvantage of using a Web interface for a database is that it typically requires substantial changes to the internal database.

A characteristic or quality describing an entity is called a(n)

Data cleansing is the same process as data scrubbing.

Describe the ways in which database technologies could be used by a toy manufacturer to achieve product differentiation.

In data mining, the technique of ________ uses a series of existing values to predict what other values will be.

Which of the following is not a method for performing a data quality audit?

The project operation

When you design the new contracts database for the publishing house mentioned above, what fields do you anticipate needing? Which of these fields might be in use in other databases used by the company?

Because HTML was designed as a cross-platform language, it is the preferred method of communicating with back-end databases.

DBMS have a(n) ________ capability to specify the structure of the content of the database.

What are the differences between data mining and OLAP? When would you advise a company to use OLAP?

A field identified in a record as holding the unique identifier for that record is called the

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.

Data governance deals with the policies and processes for managing the integrity and security of data in a firm.

A field identified in a table as holding the unique identifier of the table's records is called the

DBMS for midrange computers include all of the following except

A grouping of characters into a word, a group of words, or a complete number is called a record.