Exam 4: Databases and Datawarehouses

Julian, a database administrator, prepares data to be loaded to a data warehouse. He checks the zip code field against a reference database of zip codes to ensure that it conforms to standards. The zip codes that aren't in the standard format are reformatted. This process is called ________.

Which of the following is a function of normalization?

SQL links tables together by ________.

In a relational database, information is organized into tables in which each row represents a(n)________.

An approach that attempts to achieve consistent and uniform definitions for entities and their attributes across all business units is called ________.

Which of the following is a characteristic of structured information?

Which of the following is a good master data management strategy?

Which of the following uses databases without boundaries?

During mergers, integration of multiple databases becomes a major challenge.

Structured information can be defined as data ________.

A database schema is used to ________.

What does functional dependence mean? Illustrate with an example.

A drawback of the hierarchical database was that ________.

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

What is a database? Why is it a better system of information organization compared to a file processing system?

Trekking blindly into terabytes of data to sniff out meaningless relationships that occur just by accident is called ________.

Retrieval is very fast through data cubes because ________.

Database developers should use meaningful information for primary keys.

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

White and Brown, a legal firm, stores details of each case in physical files and folders. The firm has a back room stacked with boxes containing hundreds of files. White and Brown's storage structure resembles ________.