Exam 3: Databases and Data Warehouses

Which of the following terms represent an organized and structured collection of information?

Which of the following functions plans for, oversees the development of, and monitors the information resources of an organization?

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

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

Which of the following is a smaller, more focused data warehouse?

Which of the following systems contain information from multiple databases?

An organization's IT culture defines how the organization structures and views both the IT department and information responsibilities within it.

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

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

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

A(n) _____ is a multidimensional method of storing data for analysis.

A(n) _____ contains the logical structure for the information.

What application enables your organization to analyze competitor, customer, environmental, and internal data?

_____ is knowledge about your customers, your competitors, your partners, your competitive environment, and your own internal operations.

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.

_____ ensure the validity of database updates when multiple users attempt to access and change the same information.

Views are located within the _____ subsystem of the DBMS.

The data definition subsystem includes security management facilities.

There can be duplicate primary keys in the same file in a database.

A key consideration in today's business environment is ______ or the assigning of responsibility for ensuring the quality of information.