Exam 3: Databases and Data Warehouses

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

Multidimensional analysis tools use _____ techniques to view information from different perspectives.

Your student ID is an example of a(n) _____.

A relational database model uses a series of logically related two-dimensional tables or files to store information in the form of a database.

If your phone number was used in a clothing store to uniquely identify you as a customer, the phone number would be considered a(n) _____.

_____ are slice-and-dice techniques that allow you to view multidimensional information from different perspectives.

Business intelligence is one of the hottest topics and markets today.

A physical view represents how the users view the data.

What is another name for a database that supports OLTP?

_____ is business intelligence focused on the external competitive environment.

If you need to add a new field to a database, you would use the data manipulation system.

A data administration function would include defining and organizing database structures and contents.

Which of the following contains a subset of a data warehouse in which only a focused portion of the data is kept?

QBE allows you to query by pointing, clicking, and dragging, unlike SQL.

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.

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

Business intelligence encompasses only internal organizational information.

What is the objective of business intelligence (BI)?

_____ are databases that support OLTP.

A(n) _____ defines formats of reports and what information you want to see in a report.