Exam 3: Databases and Data Warehouses: Building Business

In an organization,_____ is responsible for the more technical and operational aspects of managing the information contained in organizational information repositories.

_____ is knowledge about your customers,your competitors,your partners,your competitive environment,and your own internal operations.

A database actually consists of three parts: information,the logical structure of that information,and tables.

An intelligent agent utilizes artificial intelligence to "discover" information in data warehouses.

Microsoft Access is an example of a(n)_____.

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

The data dictionary includes query optimization facilities.

If you were working for a large pharmaceutical company and building a sales report on current prescription writing habits of doctors,what type of information repository would you be most likely working with?

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

_____ is the gathering of input information,processing that information,and updating existing information to reflect the gathered and processed information.

What is the objective of business intelligence (BI)?

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

A(n)_____ contains facilities to help you develop transaction-intensive applications.

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

A(n)_____ is a multidimensional method of storing data for analysis.

When information is stored about a purchase or sale,what is stored in a database?

What is another name for a database that supports OLTP?

Business intelligence is knowledge about your customers,your competitors,your partners,your competitive environment,and your own internal operations.

A(n)_____ contains a subset of a data warehouse.

If an employee needs to change the details of a specific customer order,he/she would use OLTP (online transaction processing).