Question 1

The join operation

Accepted Answer

A) combines relational tables to provide the user with more information than is otherwise available. 
B) identifies the table from which the columns will be selected. 
C) creates a subset consisting of columns in a table. 
D) organizes elements into segments. 
A) combines relational tables to provide the user with more information than is otherwise available. 
B) identifies the table from which the columns will be selected. 
C) creates a subset consisting of columns in a table. 
D) organizes elements into segments.

Question 2

A data warehouse system also provides a range of ad hoc and standardized query tools,________ tools,and graphical reporting facilities.

Accepted Answer

The answer of A data warehouse system also provides a...

Question 3

A DBMS makes the

Accepted Answer

A) physical database available for different logical views. 
B) logical database available for different analytical views. 
C) physical database available for different analytical views. 
D) relational database available for different physical views. 
A) physical database available for different logical views. 
B) logical database available for different analytical views. 
C) physical database available for different analytical views. 
D) relational database available for different physical views.

Question 4

The special organizational function whose responsibilities include the technical and operational aspects of managing data,including physical database design and maintenance,is called

Accepted Answer

A) data administration. 
B) database administration. 
C) information policy administration. 
D) data auditing. 
A) data administration. 
B) database administration. 
C) information policy administration. 
D) data auditing.

Question 5

Databases record information about general categories of information referred to as ________.

Accepted Answer

The answer of Databases record information about general categories of...

Question 6

________ are applications and technologies to help users make better business decisions.

Accepted Answer

Business i

Question 7

The type of logical database model that treats data as if they were stored in two-dimensional tables is the

Accepted Answer

A) OODBMS. 
B) pre-digital DBMS. 
C) relational DBMS. 
D) hierarchical DBMS. 
A) OODBMS. 
B) pre-digital DBMS. 
C) relational DBMS. 
D) hierarchical DBMS.

Question 8

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

Accepted Answer

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

Question 9

Unlike structured data,which are generated from events such as completing a purchase transaction,unstructured data have no distinct form.

Accepted Answer

A) True 
 B)False

Question 10

Microsoft Access is a relational DBMS for desktop systems.

Accepted Answer

A) True 
 B)False

Question 11

Jill started a paint store 12 years ago.She put in a traditional file system to meet her marketing needs when she started her business.Two years later she put in a traditional file system to take care of accounting and operations.Just three years ago they put in another system to handle marketing and CRM.Jill is looking at installing another traditional file system this year to handle purchasing and SCM.Jill has been reading that perhaps they should be using a DBMS instead of these individual traditional file systems.How would you advise her and why?

Accepted Answer

Traditional file management techniques m

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

A data warehouse may be updated by a legacy system.

Accepted Answer

A) True 
 B)False

Question 14

________ are the formal rules governing the maintenance,distribution,and use of information in an organization.

Accepted Answer

Informatio

Question 15

The select,join,and project operations enable data from two different tables to be combined and only selected attributes to be displayed.

Accepted Answer

A) True 
 B)False

Question 16

Each characteristic or quality describing a particular entity is called an attribute.

Accepted Answer

A) True 
 B)False

Question 17

The most prominent data manipulation language today is ________.

Accepted Answer

Structured

Question 18

________ is where the same attribute may have different values.

Accepted Answer

The answer of ________ is where the same attribute may...

Question 19

In a relational database,complex groupings of data must be streamlined to eliminate awkward many-to-many relationships.

Accepted Answer

A) True 
 B)False

Question 20

OLAP enables users to obtain online answers to ad hoc questions in a fairly rapid amount of time,except when the data are stored in very large databases.

Accepted Answer

A) True 
 B)False

The join operation

A data warehouse system also provides a range of ad hoc and standardized query tools,________ tools,and graphical reporting facilities.

A DBMS makes the

The special organizational function whose responsibilities include the technical and operational aspects of managing data,including physical database design and maintenance,is called

Databases record information about general categories of information referred to as ________.

________ are applications and technologies to help users make better business decisions.

The type of logical database model that treats data as if they were stored in two-dimensional tables is the

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

Unlike structured data,which are generated from events such as completing a purchase transaction,unstructured data have no distinct form.

Microsoft Access is a relational DBMS for desktop systems.

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

A data warehouse may be updated by a legacy system.

________ are the formal rules governing the maintenance,distribution,and use of information in an organization.

The select,join,and project operations enable data from two different tables to be combined and only selected attributes to be displayed.

Each characteristic or quality describing a particular entity is called an attribute.

The most prominent data manipulation language today is ________.

________ is where the same attribute may have different values.

In a relational database,complex groupings of data must be streamlined to eliminate awkward many-to-many relationships.

OLAP enables users to obtain online answers to ad hoc questions in a fairly rapid amount of time,except when the data are stored in very large databases.

Information Systems in Global Business Today

How Businesses Use Information Systems

Information Systems, organizations, and Strategy

Social, ethical, and Legal Issues in Information Systems

It Infrastructure and Emerging Technologies

Telecommunications, the Internet, and Wireless Technology

Securing Information Systems

Enterprise Applications to Manage Supply Chains and Respond to Customers

E-Commerce: Digital Markets and Digital Goods

Managing Knowledge

Enhancing Decision Making

Developing Information Systems

Project Management, business Value, and Managing Change

Managing Global Systems

Filters

Exam 6: Databases and Information Management

The join operation

A data warehouse system also provides a range of ad hoc and standardized query tools,________ tools,and graphical reporting facilities.

A DBMS makes the

The special organizational function whose responsibilities include the technical and operational aspects of managing data,including physical database design and maintenance,is called

Databases record information about general categories of information referred to as ________.

________ are applications and technologies to help users make better business decisions.

The type of logical database model that treats data as if they were stored in two-dimensional tables is the

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

Unlike structured data,which are generated from events such as completing a purchase transaction,unstructured data have no distinct form.

Microsoft Access is a relational DBMS for desktop systems.

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

A data warehouse may be updated by a legacy system.

________ are the formal rules governing the maintenance,distribution,and use of information in an organization.

The select,join,and project operations enable data from two different tables to be combined and only selected attributes to be displayed.

Each characteristic or quality describing a particular entity is called an attribute.

The most prominent data manipulation language today is ________.

________ is where the same attribute may have different values.

In a relational database,complex groupings of data must be streamlined to eliminate awkward many-to-many relationships.

OLAP enables users to obtain online answers to ad hoc questions in a fairly rapid amount of time,except when the data are stored in very large databases.

Information Systems in Global Business Today

How Businesses Use Information Systems

Information Systems, organizations, and Strategy

Social, ethical, and Legal Issues in Information Systems

It Infrastructure and Emerging Technologies

Telecommunications, the Internet, and Wireless Technology

Securing Information Systems

Enterprise Applications to Manage Supply Chains and Respond to Customers

E-Commerce: Digital Markets and Digital Goods

Managing Knowledge

Enhancing Decision Making

Developing Information Systems

Project Management, business Value, and Managing Change

Managing Global Systems

Filters