Question 1

The join operation

Accepted Answer

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

Question 2

An automated or manual file that stores information about data elements and data characteristics such as usage, physical representation, ownership, authorization, and security is the

Accepted Answer

A)   data dictionary.
B)   data definition diagram.
C)   entity-relationship diagram.
D)   relationship dictionary.

Question 3

A DBMS reduces data redundancy and inconsistency by

Accepted Answer

A)   enforcing referential integrity.
B)   uncoupling program and data.
C)   utilizing a data dictionary.
D)   minimizing isolated files with repeated data.

Question 4

The small publishing company you work for wants to create a new database for storing information about all of their author contracts. What factors will influence how you design the database?

Accepted Answer

Student answers will vary, but should in...

Question 5

Every record in a file should contain at least one key field.

Accepted Answer

A) True 
 B)False

Question 6

Oracle Database Lite is a(n)

Accepted Answer

A)   DBMS for small handheld computing devices.
B)   Internet DBMS.
C)   mainframe relational DBMS.
D)   DBMS for midrange computers.

Question 7

A data warehouse may be updated by a legacy system.

Accepted Answer

A) True 
 B)False

Question 8

Data mining is a tool for allowing users to

Accepted Answer

A)   quickly compare transaction data gathered over many years.
B)   find hidden relationships in data.
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.

Question 9

A DBMS makes the

Accepted Answer

A)   physical database available for different logical views.
B)   logical database available for different analytical views.
C)   physical database available for different analytical views.
D)   logical database available for different physical views.

Question 10

Relational DBMSs use ________ rules to ensure that relationships between coupled tables remain consistent.

Accepted Answer

referentia...

Question 11

High-speed ________ use both relational and non-relational tools to analyze large datasets.

Accepted Answer

The answer of High-speed ________ use both relational and non-relational...

Question 12

In terms of data relationships, associations refers to

Accepted Answer

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.

Question 13

In a relational database, a record is referred to in technical terms as a(n)

Accepted Answer

A)   tuple.
B)   row.
C)   entity.
D)   field.

Question 14

The type of logical database model that treats data as if they were stored in two-dimensional tables is the

Accepted Answer

A)   non-relational DBMS.
B)   mobile DBMS.
C)   relational DBMS.
D)   hierarchical DBMS.

Question 15

A(n) ________ view shows data as it is actually organized and structured on the data storage media.

Accepted Answer

The answer of A(n) ________ view shows data as it...

Question 16

Detecting and correcting data in a database or file that are incorrect, incomplete, improperly formatted, or redundant is called

Accepted Answer

A)   data auditing.
B)   defragmentation.
C)   data scrubbing.
D)   data optimization.

Question 17

Databases record information about general categories of information referred to as ________.

Accepted Answer

The answer of Databases record information about general categories of...

Question 18

You are creating a database to store temperature and wind data from national airport locations. Which of the following fields is the most likely candidate to use as the basis for a primary key in the Airport table?

Accepted Answer

A)   address
B)   city
C)   airport code
D)   state

Question 19

You work for a national car rental agency and want to determine what characteristics are shared among your most loyal customers. To do this, you will want to use data mining software that is capable of

Accepted Answer

A)   identifying associations.
B)   identifying clusters.
C)   identifying sequences.
D)   classification.

Question 20

OLAP is a tool for enabling

Accepted Answer

A)   users to obtain online answers to ad-hoc questions in a rapid amount of time.
B)   users to view both logical and physical views of data.
C)   programmers to quickly diagram data relationships.
D)   programmers to normalize data.

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

Relational DBMSs use ________ rules to ensure that relationships between coupled tables remain consistent.

Correct Answerverifiedreferentia...View AnswerShow Answer

You are creating a database to store temperature and wind data from national airport locations. Which of the following fields is the most likely candidate to use as the basis for a primary key in the Airport table?

Correct AnswerverifiedShow Answer

A(n) ________ view shows data as it is actually organized and structured on the data storage media.

Correct AnswerverifiedShow Answer

High-speed ________ use both relational and non-relational tools to analyze large datasets.

Correct AnswerverifiedShow Answer

The type of logical database model that treats data as if they were stored in two-dimensional tables is the

Correct AnswerverifiedShow Answer

A DBMS reduces data redundancy and inconsistency by

Correct AnswerverifiedShow Answer

Every record in a file should contain at least one key field.

Correct AnswerverifiedShow Answer

The small publishing company you work for wants to create a new database for storing information about all of their author contracts. What factors will influence how you design the database?

Correct AnswerverifiedStudent answers will vary, but should in...View AnswerShow Answer

OLAP is a tool for enabling

Correct AnswerverifiedShow Answer

Oracle Database Lite is a(n)

Correct AnswerverifiedShow Answer

Detecting and correcting data in a database or file that are incorrect, incomplete, improperly formatted, or redundant is called

Correct AnswerverifiedShow Answer

A data warehouse may be updated by a legacy system.

Correct AnswerverifiedShow Answer

Data mining is a tool for allowing users to

Correct AnswerverifiedShow Answer

In a relational database, a record is referred to in technical terms as a(n)

Correct AnswerverifiedShow Answer

An automated or manual file that stores information about data elements and data characteristics such as usage, physical representation, ownership, authorization, and security is the

Correct AnswerverifiedShow Answer

You work for a national car rental agency and want to determine what characteristics are shared among your most loyal customers. To do this, you will want to use data mining software that is capable of

Correct AnswerverifiedShow Answer

The join operation

Correct AnswerverifiedShow Answer

In terms of data relationships, associations refers to

Correct AnswerverifiedShow Answer

Databases record information about general categories of information referred to as ________.

Correct AnswerverifiedShow Answer

A DBMS makes the

Correct AnswerverifiedShow Answer

Correct Answer
verified
referentia...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Student answers will vary, but should in...
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

Correct Answer
verified

Correct Answer
verified