Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

Which of the following database types would be best suited for storing multimedia?

Accepted Answer

A) SQL DBMS 
B) Open-source DBMS 
C) Non-relational DBMS 
D) Cloud-based database 
A) SQL DBMS 
B) Open-source DBMS 
C) Non-relational DBMS 
D) Cloud-based database

Question 3

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

Question 4

A(n)________ is a structured survey of the accuracy and level of completeness of the data in an information system.

Accepted Answer

A) data quality audit 
B) systems analysis 
C) systems audit 
D) data analysis 
A) data quality audit 
B) systems analysis 
C) systems audit 
D) data analysis

Question 5

MySQL is a:

Accepted Answer

A) DBMS for small handheld computing devices. 
B) popular open-source DBMS. 
C) mainframe relational DBMS. 
D) DBMS for desktop systems. 
A) DBMS for small handheld computing devices. 
B) popular open-source DBMS. 
C) mainframe relational DBMS. 
D) DBMS for desktop systems.

Question 6

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 7

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

Accepted Answer

A) True 
 B)False

Question 8

Access is a:

Accepted Answer

A) DBMS for small handheld computing devices. 
B) popular open-source DBMS. 
C) DBMS for midrange computers. 
D) DBMS for desktop PC systems. 
A) DBMS for small handheld computing devices. 
B) popular open-source DBMS. 
C) DBMS for midrange computers. 
D) DBMS for desktop PC systems.

Question 9

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. 
A) data auditing. 
B) defragmentation. 
C) data scrubbing. 
D) data optimization.

Question 10

A data warehouse is typically comprised of several smaller data marts.

Accepted Answer

A) True 
 B)False

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

The most prominent data manipulation language today is:

Accepted Answer

A) Access. 
B) DB2. 
C) SQL. 
D) Crystal Reports. 
A) Access. 
B) DB2. 
C) SQL. 
D) Crystal Reports.

Question 13

Which of the following statements about data warehouses is not true?

Accepted Answer

A) They store supply data to be used across the enterprise for management analysis and decision making. 
B) Data warehouse systems provide a range of ad hoc and standardized query tools, analytical tools, and graphical reporting facilities. 
C) They may include data from Web site transactions. 
D) Data warehouse systems provide easy-to-use tools for managers to easily update data. 
A) They store supply data to be used across the enterprise for management analysis and decision making. 
B) Data warehouse systems provide a range of ad hoc and standardized query tools, analytical tools, and graphical reporting facilities. 
C) They may include data from Web site transactions. 
D) Data warehouse systems provide easy-to-use tools for managers to easily update data.

Question 14

A one-to-many relationship between two entities is symbolized in a diagram by a line that ends:

Accepted Answer

A) in two short marks. 
B) in one short mark. 
C) with a crow's foot. 
D) with a crow's foot preceded by a short mark. 
A) in two short marks. 
B) in one short mark. 
C) with a crow's foot. 
D) with a crow's foot preceded by a short mark.

Question 15

OLAP is a key tool of BI.

Accepted Answer

A) True 
 B)False

Question 16

Implementing a Web interface for a database requires changes to the database itself.

Accepted Answer

A) True 
 B)False

Question 17

A table that links two tables that have a many-to-many relationship is often called a(n):

Accepted Answer

A) derived table. 
B) intersection relation. 
C) foreign table. 
D) entity-relationship table. 
A) derived table. 
B) intersection relation. 
C) foreign table. 
D) entity-relationship table.

Question 18

A schematic of the entire database that describes the relationships in a database is called a(n):

Accepted Answer

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

Question 19

A small publishing house that you work for would like to develop a database that keeps track of the contracts that authors and publishers sign before starting a book. What fields do you anticipate needing for this database? Identify at least seven fields. Which of these fields might be in use in other databases within the firm?

Accepted Answer

Author first name, author last name, aut

Question 20

Which of the following best illustrates the relationship between entities and attributes?

Accepted Answer

A) The entity CUSTOMER with the attribute PRODUCT 
B) The entity CUSTOMER with the attribute ADDRESS 
C) The entity PRODUCT with the attribute PURCHASE 
D) The entity PRODUCT with the attribute CUSTOMER 
A) The entity CUSTOMER with the attribute PRODUCT 
B) The entity CUSTOMER with the attribute ADDRESS 
C) The entity PRODUCT with the attribute PURCHASE 
D) The entity PRODUCT with the attribute CUSTOMER

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

Which of the following database types would be best suited for storing multimedia?

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

A(n)________ is a structured survey of the accuracy and level of completeness of the data in an information system.

MySQL is a:

In clustering, a data mining tool will:

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

Access is a:

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

A data warehouse is typically comprised of several smaller data marts.

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

The most prominent data manipulation language today is:

Which of the following statements about data warehouses is not true?

A one-to-many relationship between two entities is symbolized in a diagram by a line that ends:

OLAP is a key tool of BI.

Implementing a Web interface for a database requires changes to the database itself.

A table that links two tables that have a many-to-many relationship is often called a(n):

A schematic of the entire database that describes the relationships in a database is called a(n):

Which of the following best illustrates the relationship between entities and attributes?

Business Information Systems in Your Career

Global E-Business and Collaboration

Achieving Competitive Advantage With Information Systems

Ethical and Social Issues in 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

Filters

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

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

Which of the following database types would be best suited for storing multimedia?

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

A(n)________ is a structured survey of the accuracy and level of completeness of the data in an information system.

MySQL is a:

In clustering, a data mining tool will:

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

Access is a:

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

A data warehouse is typically comprised of several smaller data marts.

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

The most prominent data manipulation language today is:

Which of the following statements about data warehouses is not true?

A one-to-many relationship between two entities is symbolized in a diagram by a line that ends:

OLAP is a key tool of BI.

Implementing a Web interface for a database requires changes to the database itself.

A table that links two tables that have a many-to-many relationship is often called a(n):

A schematic of the entire database that describes the relationships in a database is called a(n):

Which of the following best illustrates the relationship between entities and attributes?

Business Information Systems in Your Career

Global E-Business and Collaboration

Achieving Competitive Advantage With Information Systems

Ethical and Social Issues in 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

Filters