Exam 3: Databases and Data Warehouses

A(n) _____ is a multidimensional representation of information.

According to your textbook, a(n) _____ permits you to see the contents of a database file, change the contents, and sort the file.

In a data warehouse, which tool would you use to build reports quickly and without having to write programming code?

If you were able to quickly pull information from student records with course records to build students' schedules, you would be using a _____ tool.

A database management system contains five important software components. Which of the following components allows you to add, change, and delete information in a relational database?

What is a data warehouse?

Data warehouses support transaction processing.

A database management system contains five important software components. Which of the following components accepts and processes requests from the other four database components?

Which term refers to a specific piece of data that is stored in a database file?

Data-mining tools are used to mine a data warehouses and extrapolate the business intelligence needed to make decisions, solve problems, or capitalize on an opportunity to create a competitive advantage.

The logical view of information focuses on how you arrange and access information to meet the needs of the business.

_____ is the manipulation of information to support decision making.

Report generators help you quickly define formats of reports and what information you want to see in a report.

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

A senior manager who analyzes internal and external information to analyze marketing campaigns and their affect on customer buying habits is using which type of application?

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

A database actually consists of two distinct parts: information and the logical structure of that information.

_____ systems provide managers with actionable information and knowledge.

A primary key from one file and a foreign key from another file are used to create a relationship between two files in a relational database.

The _____ helps you add, change, and delete information in a database and mine it for valuable information.