Exam 3: Databases and Data Warehouses: Building Business

Which of the following are large electronic repositories of very detailed information?

The _____ uses a series of logically related two-dimensional tables or files to store information in the form of a database.

Multidimensional analysis tools use _____ techniques to view information from different perspectives.

Foreign keys uniquely identify records.

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.

A database management system contains five important software components.Which of the following components allows you to define the structure of a database?

QBE allows you to query by pointing,clicking,and dragging,unlike SQL.

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

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

Data administration is the function in an organization that is responsible for the more technical and operational aspects of managing the information contained in organizational information repositories.

What is a hypercube?

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

A hypercube is a two-dimensional representation of information.

_____ is a standardized fourth-generation query language found in most DBMSs.

A(n)_____ subsystem permits the user to develop transaction-intensive applications.

Which part of a relational database contains the logical structure for the information?

A(n)_____ subsystem controls facilities for backing up the database and establishing security.

Intelligent agents are used in OLAP and in online searching.