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