Exam 4: Databases and DataWarehouses

Making changes to an integrated database is considered a challenge because ________.

________ is a process that refines entities and their relationships to help minimize duplication of information in tables.

Databases that are smaller than enterprise databases and focus on their creators' specific information requirements are known as ________.

________ ensures that every foreign key entry actually exists as a primary key entry in its main table.

A marketing representative who wants to put a positive spin on a tally of recent orders chooses to include orders that have been canceled in his report. This report exemplifies high-quality data.

The database performance tuning process takes into account ________.

Which of the following is the most widely used database architecture?

How does metadata differ for different types of information?

Changes to an integrated database take less time from IT but more from the end users.

An organization's data warehouse contains information drawn from multiple sources that can be used for analysis, intelligence gathering, and strategic planning.

Aban Constructions Limited, a construction company, maintains data in the form of records within tables, and the tables are interconnected by linking matching fields. Which type of database architecture does Aban Constructions Limited use?

Which of the following is used to spot trends, identify patterns, generate reports for compliance purposes, do research, and plan strategies?

Which of the following ensures that there will be minimum redundancy in a relational database?

One of the disadvantages of interactive voice response (IVR) is that it cannot handle massive call volumes.

Batch processing is defined as ________.

Databases in which people outside the enterprise enter and manage most of the records are termed as ________.

What does functional dependence mean? Illustrate with an example.

SQL links tables together by ________.

Shadow systems are managed by individuals or departments and not by the central IT staff in an organization.

Which of the following database architectures relies on a cooperating collection of existing databases?