Question 1

A foreign key is a field that links to a separate table.

Accepted Answer

A) True 
 B)False

Question 2

In linking databases to the Web,the role of the application server is to host the DBMS.

Accepted Answer

A) True 
 B)False

Question 3

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)  foreign key.

Question 4

What is the purpose of a DBMS's data definition function?

Accepted Answer

A)  Storing and managing the data in the database
B)  Storing definitions of data elements
C)  Normalizing the database
D)  Structuring the database

Question 5

Describe the ways in which database technologies could be used by an office stationery supply company to achieve product differentiation.

Accepted Answer

Product databases could be made availabl...

Question 6

Common Gateway Interface is a specification for processing data on a Web server.

Accepted Answer

A) True 
 B)False

Question 7

________ is an approach to data management that stores both data and procedures acting on the data as objects that can be automatically retrieved and shared.

Accepted Answer

A)  Referential integrity
B)  Normalization
C)  An object-oriented DBMS
D)  Entity-relationship modelling

Question 8

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

Accepted Answer

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

Question 9

End users use a data manipulation language to manipulate data in the database.

Accepted Answer

A) True 
 B)False

Question 10

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 11

The logical view of a database:

Accepted Answer

A)  shows how data are organized and structured on the storage media.
B)  presents an entry screen to the user.
C)  allows the creation of supplementary reports.
D)  presents data as they would be perceived by end users.

Question 12

In terms of the data relationships found by data mining,sequences 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

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 14

In a table for customers,the information about a single customer would reside in a single:

Accepted Answer

A)  field.
B)  row.
C)  column.
D)  table.

Question 15

In a relational database,a record is also called a(n) :

Accepted Answer

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

Question 16

As per your reading of the chapter opening case,which of the following best describes the challenges faced by Banco de Crédito del Perú (BCP) ?

Accepted Answer

A)  BCP's choice of software had led to erroneous data.
B)  BCP had too much data being collected.
C)  BCP had multiple,redundant,and error-prone sources of data.
D)  BCP was collecting data that was not relevant to its new goals.

Question 17

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.

Question 18

The small publishing company you work for wants to create a new database for storing information about all of their author contracts.What difficulties do you anticipate?

Accepted Answer

Data accuracy when the new data is input...

Question 19

In clustering,a data mining tool will:

Accepted Answer

A)  find new groupings within data.
B)  find related predictions from existing values.
C)  find several events grouped by time.
D)  find new associations.

Question 20

Which of the following best describes the importance of creating an accurate data model for your business's database?

Accepted Answer

A)  It is not essential,as the data model itself is modified by the database continuously.
B)  Critical,as without one,your data may be inaccurate,incomplete,or difficult to retrieve.
C)  Essential,as table relationships cannot be created without an accurate data model.
D)  Somewhat important,as the type of data model will define what kinds of data will be stored.

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

As per your reading of the chapter opening case,which of the following best describes the challenges faced by Banco de Crédito del Perú (BCP) ?

Correct AnswerverifiedShow Answer

The project operation:

Correct AnswerverifiedShow Answer

________ is an approach to data management that stores both data and procedures acting on the data as objects that can be automatically retrieved and shared.

Correct AnswerverifiedShow Answer

In clustering,a data mining tool will:

Correct AnswerverifiedShow Answer

The logical view of a database:

Correct AnswerverifiedShow Answer

In a relational database,a record is also called a(n) :

Correct AnswerverifiedShow Answer

What is the purpose of a DBMS's data definition function?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Which of the following best describes the importance of creating an accurate data model for your business's database?

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

The small publishing company you work for wants to create a new database for storing information about all of their author contracts.What difficulties do you anticipate?

Correct AnswerverifiedData accuracy when the new data is input...View AnswerShow Answer

OLAP is a tool for enabling:

Correct AnswerverifiedShow Answer

In linking databases to the Web,the role of the application server is to host the DBMS.

Correct AnswerverifiedShow Answer

In a table for customers,the information about a single customer would reside in a single:

Correct AnswerverifiedShow Answer

A foreign key is a field that links to a separate table.

Correct AnswerverifiedShow Answer

End users use a data manipulation language to manipulate data in the database.

Correct AnswerverifiedShow Answer

In terms of the data relationships found by data mining,sequences refers to:

Correct AnswerverifiedShow Answer

Common Gateway Interface is a specification for processing data on a Web server.

Correct AnswerverifiedShow Answer

Describe the ways in which database technologies could be used by an office stationery supply company to achieve product differentiation.

Correct AnswerverifiedProduct databases could be made availabl...View AnswerShow 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

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
Data accuracy when the new data is input...
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
Product databases could be made availabl...
View Answer

Correct Answer
verified