Exam 5: Foundations of Business Intelligence: Databases and Information Management

The confusion created by ________ makes it difficult for companies to create customer relationship management,supply chain management,or enterprise systems that integrate data from different sources.

A data ________ stores current and historical data of potential interest to decision makers throughout the company.

List at least two ways that a business's data can become redundant or inconsistent.

In a relational database,the three basic operations used to develop useful sets of data are:

An information policy specifies the procedures and rules for defining the structure and content of corporate databases.

Both Oracle and Microsoft Access use SQL to retrieve information from the database.

OLAP is a key tool of BI.

A data warehouse may include information from legacy systems.

Relational database systems use ________ to ensure that relationships between coupled tables remain consistent.

Data mining is a tool for allowing users to:

Predictive analysis is a technique of data mining.

A data warehouse is typically comprised of several smaller data marts.

A firm's information policy lays out who is responsible for updating and maintaining the information in a database system.

The most prominent data manipulation language today is:

The tool that enables users to view the same data in different ways using multiple dimensions is:

A table that links two tables that have a many-to-many relationship is often called a(n):

A DBMS makes the:

Within a corporate information services department,the task of creating the physical database and its logical relations are responsibilities of the ________ function.

Which of the following best illustrates the relationship between entities and attributes?

You are working in the IT department of a small paper supply company and planning a new database that monitors employee benefits and productivity.What would be the relationship you need to establish between Employee_ID in the Employee table and Parking_spot_number in the Perks table?