Question 1

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

Accepted Answer

A)   primary key.
B)   key field.
C)   primary field.
D)   unique ID.

Question 2

DBMS for midrange computers include all of the following except

Accepted Answer

A)   DB2.
B)   Oracle.
C)   Microsoft SQL Server.
D)   Microsoft Access.

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

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

Accepted Answer

The answer of DBMS have a(n) ________ capability to specify...

Question 5

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

Accepted Answer

The select operation creates a subset co...

Question 6

The project operation

Accepted Answer

A)   combines relational tables to provide the user with more information than is otherwise available.
B)   creates a subset consisting of columns in a table.
C)   organizes elements into segments.
D)   identifies the table from which the columns will be selected.

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

The answer of In data mining, the technique of ________...

Question 9

Data cleansing is the same process as data scrubbing.

Accepted Answer

A) True 
 B)False

Question 10

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?

Accepted Answer

Author first name, author last name, aut...

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

Data mining uncovers hidden relationship...

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

A)   primary key.
B)   key field.
C)   primary field.
D)   unique ID.

Question 15

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?

Accepted Answer

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

Question 16

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.

Accepted Answer

A)   batch processing
B)   data redundancy
C)   data independence
D)   online processing

Question 17

The data dictionary serves as an important data management tool by

Accepted Answer

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.

Question 18

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

Accepted Answer

A)   field.
B)   tuple.
C)   key field.
D)   attribute.

Question 19

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

Accepted Answer

A)   surveying entire data files
B)   surveying samples from data files
C)   surveying data definition and query files
D)   surveying end users about their perceptions of data quality

Question 20

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

Accepted Answer

Product databases could be made availabl...

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

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

Correct AnswerverifiedProduct databases could be made availabl...View AnswerShow Answer

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.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

DBMS for midrange computers include all of the following except

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

The data dictionary serves as an important data management tool by

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Data cleansing is the same process as data scrubbing.

Correct AnswerverifiedShow Answer

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?

Correct AnswerverifiedAuthor first name, author last name, aut...View AnswerShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedThe select operation creates a subset co...View AnswerShow Answer

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?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

The project operation

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedData mining uncovers hidden relationship...View AnswerShow Answer

Correct Answer
verified
Product databases could be made availabl...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Author first name, author last name, aut...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
The select operation creates a subset co...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Data mining uncovers hidden relationship...
View Answer