Question 1

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 2

DBMS for midrange computers include all of the following except

Accepted Answer

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

Question 3

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 4

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 5

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

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

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 8

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 9

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 
A)  batch processing 
B)  data redundancy 
C)  data independence 
D)  online processing

Question 10

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 11

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 12

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

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

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 15

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

Question 16

Data cleansing is the same process as data scrubbing.

Accepted Answer

A) True 
 B)False

Question 17

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 
A)  data normalization 
B)  data accuracy 
C)  data redundancy 
D)  data inconsistency

Question 18

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

Question 19

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 20

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

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

DBMS for midrange computers include all of the following except

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

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

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

The data dictionary serves as an important data management tool by

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

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?

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.

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

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

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

The project operation

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

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

Data cleansing is the same process as data scrubbing.

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 field identified in a record as holding the unique identifier for that record is called the

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

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

Information Systems in Global Business Today

Global E-Business and Collaboration

Information Systems, Organizations, and Strategy

Ethical and Social Issues in Information Systems

IT Infrastructure and Emerging Technologies

Telecommunications, the Internet, and Wireless Technology

Securing Information Systems

Achieving Operational Excellence and Customer Intimacy: Enterprise Applications

E-Commerce: Digital Markets, Digital Goods

Managing Knowledge

Enhancing Decision Making

Building Information Systems

Managing Projects

Managing Global Systems

Filters

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

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

DBMS for midrange computers include all of the following except

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

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

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

The data dictionary serves as an important data management tool by

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

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?

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.

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

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

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

The project operation

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

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

Data cleansing is the same process as data scrubbing.

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 field identified in a record as holding the unique identifier for that record is called the

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

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

Information Systems in Global Business Today

Global E-Business and Collaboration

Information Systems, Organizations, and Strategy

Ethical and Social Issues in Information Systems

IT Infrastructure and Emerging Technologies

Telecommunications, the Internet, and Wireless Technology

Securing Information Systems

Achieving Operational Excellence and Customer Intimacy: Enterprise Applications

E-Commerce: Digital Markets, Digital Goods

Managing Knowledge

Enhancing Decision Making

Building Information Systems

Managing Projects

Managing Global Systems

Filters