Exam 3: Databases and Data Warehouses: Supporting the Analytics-Driven Organization

A(n)_____ is a logical collection of information gathered from many different operational databases used to create business intelligence that supports business analysis activities and decision-making tasks.

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

A(n)_____ key is a primary key of one file that appears in another file.

_____ are rules that help ensure the quality of the information in a database file.

Who,among the following,is responsible for ensuring that information is used in an ethical way?

A(n)_____ is a primary key from one table placed within a second table to establish a relationship between the two tables.

Query-by-example tools rely heavily upon the _____ within a database to find information.

The most popular database model is the hierarchical database model.

_____ is the manipulation of information to support decision making.

_____ include(s)tools such as neural networks and fuzzy logic to form the basis of "information discovery."

What type of software tool is used to query information stored in a data warehouse?

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

The CSO is responsible for ensuring that only the right people have access to certain types of information such as financial records,payroll,and health care.

A(n)_____ represents how data is physically arranged,stored,and accessed on some type of storage device.

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?

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?

Which of the following functions plans for,oversees the development of,and monitors the information resource of an organization?

A(n)_____ is a subset of a data warehouse in which only a focused portion of the data warehouse information is kept.

A _____ is a special form of a database that contains information gathered from operational databases for the purpose of supporting decision-making tasks.

Data warehouses do not support transaction processing.