Exam 3: Databases and Data Warehouses

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

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

Which system allows your organization to gather, process, and update transactional information?

Which organizational function is responsible for the more technical and operational aspects of managing information repositories?

The term relation often describes each _____ table or file in the relational model.

Data-mining tools include all but which of the following?

A(n) _____ allows you to see the contents of a database file, make whatever changes you want, perform simple sorting, and query to find the location of specific information.

Which type of constraint ensures the quality of information in a relational database?

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

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

Every primary key can also be a _____ key.

A database management system (DBMS) allows you to specify the logical organization for a database and access and use the information within a database.

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

What is SQL?

A hypercube is a multidimensional representation of information.

What is the difference between data administration and database administration?

Which data warehouse tools are slice-and-dice techniques that allow you to view multidimensional information from different perspectives?

Which data manipulation tool allows you to graphically design the answer to your business questions?

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

Data-mining tools support the concept of OLTP in manipulating information to support decisions.