MIS Ch. 3 Quiz

_____ ensure the validity of database updates when multiple users attempt to access and change the same information.

Concurrency control facilities

If you were looking at information in a database and you are able to see only the information you needed in the format you wanted, what type of database view is it?

Logical view

Multidimensional analysis (MDA) tools are slice-and-dice techniques that allow you to view multidimensional information from different perspectives.

True

The digital dashboard is designed uniquely for each individual user.

True

A hypercube is:

a multidimensional representation of information.

If you were viewing information from different perspectives in a multidimensional analysis, you would be ____.

turning the cube

A report generator allows you to see the contents of a database file, make whatever changes you want, perform simple sorting, and query to find the location of specific information.

False

Application generation facilities are most often used by operations personnel.

False

Data administration is the function in an organization that is responsible for the more technical and operational aspects of managing the information contained in organizational information repositories.

False

Data marts focus on the entire organization, while data warehouses focus on specific needs.

False

Orco Corp. would like to determine advertising strategies for customers who buy high-priced products. It would use OLTP on its data warehouse to accomplish this task.

False

The physical view of information focuses on how you as a knowledge worker need to arrange and access information to meet your particular business needs.

False

Which of the following DBMS components allows you to quickly develop computer routines or tasks that will process your business transactions?

Application generation subsystem

Which of the following DBMS components allows you to add, change, and delete information in a relational database?

Data manipulation subsystem

Which organizational function is responsible for the more technical and operational aspects of managing information repositories?

Database administration

Application generation facilities are most often used by what group of employees?

IT specialists

If you were a programmer and needed to view information as it was stored by the database, what type of database view would you see?

Physical view

_____ facilities find the "shortest route" to the information you want so you don't have to.

Query optimization facilities

Which data manipulation tool allows you to graphically design the answer to your business questions?

Query-by-example tools

Which of the following data administration facilities continually maintain statistics concerning how the DBMS engine physically accesses information?

Reorganization facilities

What is the difference between multidimensional analysis and statistical analysis?

Statistical analysis is a mathematical approach to understanding information whereas multidimensional analysis is a way of viewing information from different perspectives.

What does it mean for a data warehouse to be multidimensional?

The files stored in a warehouse contain several layers of columns and rows.

What must you define before adding any information to a relational database?

The logical structure of the database

A _____ is a collection of information that you organize and access according to the logical structure of that information.

database

Databases that support OLTP are most often referred to as ____.

operational databases