Exam 4: Databases and DataWarehouses

A drawback of the hierarchical database was that ________.

________ takes advantage of signals transmitted via the phone to access a database, retrieve account information, and enter data.

Which of the following uses databases without boundaries?

How are databases used across organizational boundaries? Illustrate with an example.

What are the ways in which information is classified in terms of structure? Explain with examples.

An integrated collection of information that is logically related and stored in such a way as to minimize duplication and facilitate rapid retrieval is called a ________.

A field or a group of fields that make a record unique in a table is called a(n) ________.

Which of the following is a characteristic of structured information?

Building interfaces, or bridges, between different databases to link common fields is an integration strategy.

Describe performance tuning and the trade-offs associated with it.

Companies often use different relational DBMS for their data warehouse and operational database.

To balance the information needs of multiple stakeholders, top-level managers need clear, consistent, and accurate reports that summarize information from across the enterprise.

Structured information can be defined as data ________.

Shadow systems focus on ________.

Databases are created and handled using ________.

Which database architecture is popularly used for organizing complex data types such as graphics and multimedia?

A representation of an entity in a meaningful way, which includes the attributes of the entity, is called a ________.

One goal of normalization is to ________.

What are the database ownership issues faced by management at a typical company?

A separate file processing system leads to the creation of redundant information because ________.