Question 1

DBMS typically include report-generating tools in order to:

Accepted Answer

A) retrieve and display data. 
B) display data in an easier-to-read format. 
C) display data in graphs. 
D) perform predictive analysis. 
A) retrieve and display data. 
B) display data in an easier-to-read format. 
C) display data in graphs. 
D) perform predictive analysis.

Question 2

What is the first step you should take in managing data for a firm?

Accepted Answer

A) Identify the data needed to run the business 
B) Cleanse the data before importing it to any database 
C) Normalize the data before importing to a database 
D) Audit your data quality 
A) Identify the data needed to run the business 
B) Cleanse the data before importing it to any database 
C) Normalize the data before importing to a database 
D) Audit your data quality

Question 3

A(n)________ is a dedicated computer in a client/server environment that hosts a DBMS.

Accepted Answer

A) web server 
B) application server 
C) database server 
D) client server 
A) web server 
B) application server 
C) database server 
D) client server

Question 4

Many applications today require databases that can store and retrieve multimedia.

Accepted Answer

A) True 
 B)False

Question 5

The select 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) identifies the table from which the columns will be selected. 
D) creates a subset consisting of all records in the file that meets stated criteria. 
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) identifies the table from which the columns will be selected. 
D) creates a subset consisting of all records in the file that meets stated criteria.

Question 6

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 7

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

Accepted Answer

A) True 
 B)False

Question 8

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 9

One of the drawbacks to OODBMS is that they cannot work with applets.

Accepted Answer

A) True 
 B)False

Question 10

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 systems. 
A) DBMS for small handheld computing devices. 
B) popular open-source DBMS. 
C) DBMS for midrange computers. 
D) DBMS for desktop systems.

Question 11

A data mart usually can be constructed more rapidly and at lower cost than a data warehouse because:

Accepted Answer

A) it typically focuses on a single subject area or line of business. 
B) all the information is historical. 
C) it uses a Web interface. 
D) all of the information belongs to a single company. 
A) it typically focuses on a single subject area or line of business. 
B) all the information is historical. 
C) it uses a Web interface. 
D) all of the information belongs to a single company.

Question 12

Which of the following database types is useful for storing Java applets as well as handling large numbers of transactions?

Accepted Answer

A) Relational DBMS 
B) Hierarchical DBMS 
C) Object-relational DBMS 
D) OODBMS 
A) Relational DBMS 
B) Hierarchical DBMS 
C) Object-relational DBMS 
D) OODBMS

Question 13

List and describe three main capabilities or tools of a DBMS.

Accepted Answer

A DBMS includes capabilities and tools f

Question 14

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

Accepted Answer

The select operation creates a subset co

Question 15

Businesses use ________ tools to search and analyze unstructured data sets,such as e-mails and memos.

Accepted Answer

A) OODBMS 
B) Web mining 
C) text mining 
D) OLAP 
A) OODBMS 
B) Web mining 
C) text mining 
D) OLAP

Question 16

What types of relationships are possible in a relational database? Describe and give an example of each.

Accepted Answer

There are three types of relationships:

Question 17

Data mining is more ________ than OLAP.

Accepted Answer

A) data focused 
B) multidimensional 
C) query oriented 
D) discovery driven 
A) data focused 
B) multidimensional 
C) query oriented 
D) discovery driven

Question 18

Data cleansing is the same process as data scrubbing.

Accepted Answer

A) True 
 B)False

Question 19

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 20

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.

DBMS typically include report-generating tools in order to:

What is the first step you should take in managing data for a firm?

A(n)________ is a dedicated computer in a client/server environment that hosts a DBMS.

Many applications today require databases that can store and retrieve multimedia.

The select operation:

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

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

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

One of the drawbacks to OODBMS is that they cannot work with applets.

Access is a:

A data mart usually can be constructed more rapidly and at lower cost than a data warehouse because:

Which of the following database types is useful for storing Java applets as well as handling large numbers of transactions?

List and describe three main capabilities or tools of a DBMS.

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

Businesses use ________ tools to search and analyze unstructured data sets,such as e-mails and memos.

What types of relationships are possible in a relational database? Describe and give an example of each.

Data mining is more ________ than OLAP.

Data cleansing is the same process as data scrubbing.

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

MySQL is a:

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

DBMS typically include report-generating tools in order to:

What is the first step you should take in managing data for a firm?

A(n)________ is a dedicated computer in a client/server environment that hosts a DBMS.

Many applications today require databases that can store and retrieve multimedia.

The select operation:

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

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

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

One of the drawbacks to OODBMS is that they cannot work with applets.

Access is a:

A data mart usually can be constructed more rapidly and at lower cost than a data warehouse because:

Which of the following database types is useful for storing Java applets as well as handling large numbers of transactions?

List and describe three main capabilities or tools of a DBMS.

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

Businesses use ________ tools to search and analyze unstructured data sets,such as e-mails and memos.

What types of relationships are possible in a relational database? Describe and give an example of each.

Data mining is more ________ than OLAP.

Data cleansing is the same process as data scrubbing.

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

MySQL is a:

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