Exam 5: Database Systems, Data Centres, and Business Intelligence

The DBMS serves as an interface between an application program and the database.

A data warehouse is used to support decision making while an OLTP database is used to support transaction processing.

The domain for pay rate would include both positive and negative numbers.

Which of the following stores the database on a service provider's server and allows the client to access the database over a network?

What information-analysis tool involves the automated discovery of patterns and relationships in a data warehouse?

A database need not reflect the business processes of the organization.

Data mining involves the automated discovery of patterns and relationships in a data warehouse.

Entity-relationship diagrams are a useful database design tool.

Oracle is currently the market leader in general-purpose databases, with about three-quarters of the multibillion-dollar database market.

Better access to data and information and improved data integrity are two advantages of the ____________________ approach.

____________________ control can be used to avoid potential problems when two or more users attempt to access the same record at the same time.

A database provides an essential foundation for an organization's information and decision support systems.

What standardized data manipulation language, developed in the 1970s, allows programmers to use one powerful language on a variety of systems?

Carrying summary totals in the data records is an example of planned data redundancy.

A(n) ____________________ is a climate-controlled building that houses database servers and systems that deliver mission-critical information and services.

The senior executives of a multinational company just received the quarterly financial report of their company broken down by country; each country was broken down further by region.The data collected was aggregated and presented in an efficient manner.What type of tool was used to generate this report?

A DBMS provides one of many points of management and control over data resources.

Which of the following terms refers to the logical and physical structure of the data and the relationships among the data for each user?

What is a database a collection of?

The raw data necessary to make sound business decisions is stored in a variety of locations and formats.