Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

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. 
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 3

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

Accepted Answer

A) True 
 B)False

Question 4

________ 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 
A) Referential integrity 
B) Normalization 
C) An object-oriented DBMS 
D) Entity-relationship modelling

Question 5

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

Accepted Answer

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

Question 6

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 7

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. 
A) data dictionary. 
B) data definition diagram. 
C) entity-relationship diagram. 
D) relationship dictionary.

Question 8

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. 
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 9

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

Accepted Answer

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

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

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. 
A) primary key. 
B) key field. 
C) primary field. 
D) foreign key.

Question 13

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. 
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.

Question 14

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 15

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. 
A) field. 
B) row. 
C) column. 
D) table.

Question 16

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. 
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 17

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. 
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 18

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. 
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 19

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 
A) Storing and managing the data in the database 
B) Storing definitions of data elements 
C) Normalizing the database 
D) Structuring the database

Question 20

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. 
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.

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

OLAP is a tool for enabling:

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

________ 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.

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

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

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:

The logical view of a database:

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

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

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

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

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

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?

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

In clustering,a data mining tool will:

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

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)?

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

The project operation:

Business Information Systems in Your Career

Global E-Business and Collaboration

Achieving Competitive Advantage With Information Systems

IT Infrastructure: Hardware and Software

Telecommunications, the Internet, and Wireless Technology

Securing Information Systems

Achieving Operational Excellence and Customer Intimacy: Enterprise Applications

E-Commerce: Digital Markets,digital Goods

Improving Decision Making and Managing Knowledge

Building Information Systems and Managing Projects

Ethical and Social Issues in Information Systems

Filters

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

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

OLAP is a tool for enabling:

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

________ 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.

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

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

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:

The logical view of a database:

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

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

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

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

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

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?

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

In clustering,a data mining tool will:

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

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)?

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

The project operation:

Business Information Systems in Your Career

Global E-Business and Collaboration

Achieving Competitive Advantage With Information Systems

IT Infrastructure: Hardware and Software

Telecommunications, the Internet, and Wireless Technology

Securing Information Systems

Achieving Operational Excellence and Customer Intimacy: Enterprise Applications

E-Commerce: Digital Markets,digital Goods

Improving Decision Making and Managing Knowledge

Building Information Systems and Managing Projects

Ethical and Social Issues in Information Systems

Filters