Exam 3: Databases and Data Warehouses: Building Business

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

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

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

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

_____ allows you to query by pointing,clicking,and dragging and then specifying a selection criteria.

_____ permit users to examine the impact of proposed structural changes on a database.

_____ and _____ both extract data meeting specific criteria from a database,but have different user interfaces.

A primary key must consist of one and only one field.

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

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

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

_____ is the manipulation of information to support decision making.

Which type of database stores data in a series of logically related two-dimensional tables or files?

The data administration subsystem is used to create the data dictionary.

If a salesperson attempts to order merchandise for a customer not in the customer database,the database will typically generate an error message.This message indicates that a(n)_____ has been violated.

_____ are software tools used to query information in a data warehouse.

Query-by-example tools rely heavily upon the _____ within a database to find information.

If you were to perform a regression analysis,what type of data warehouse tool would you use?

What is a data warehouse?

What is the type of field,or group of fields,that can uniquely identify each record in a database?