Exam 3: Databases and Data Warehouses

A(n) _____ subsystem contains facilities for concurrency control.

The primary key of the Customer file is the Customer ID field and the primary key of the Order file is the Order ID field. Therefore, the _____ field would be used to create a logical relationship between the Customer and Order files.

Which database management subsystem is responsible for backup and recovery, security management, query optimization, concurrency control, and change management?

Query-by-example (QBE) tools help you graphically design the answer to a question.

If you were viewing information from different perspectives, you would be _____.

Which application supports the manipulation of information to support decision making?

Structured query language (SQL) is a standardized first-generation query language found in most DBMSs.

There is no way to examine the impact of proposed changes on an existing database.

What is the term used to describe the sharing of information regardless of title or department.

If you were comparing information from various divisions of an organization for instance, sales, marketing, and production, what type of information repository would you most likely work with?

A(n) _____ subsystem is used to create and maintain the data dictionary.

A(n) _____ subsystem controls facilities for change management.

Which data manipulation tool allows you to quickly define the formats of needed business reports from information stored in a database?

A database consists of _____ and the _____.

The data dictionary includes query optimization facilities.

The data manipulation subsystem is often the interface between the user and the information contained in the database.

A primary key is a field that uniquely describes each record.

What is another name for a database?

_____ maintain statistics regarding how the DBMS engine physically accesses information.

Intelligent agents are used in OLAP and in online searching.