Exam 11: Behind the Scenes: Databases and Information Systems

Data in a multidimensional database is organized in a ________ format.

Which of the following is NOT a likely primary key?

You would use a ________ to temporarily display records of residents of the city of Boston.

A large data mart might require a database administrator to design, construct, and maintain it.

A(n)________ provides a view of data fields to be filled in with appropriate labels to assist a user in entering data into the database.

________ is used to ensure that data is organized most efficiently.

________ is used to analyze large amounts of data and identify unseen patterns or trends.

________ means that for each value in the foreign key of one table, there is a corresponding value in the primary key of another table.

In a relational database, a(n)________ relationship indicates that a record that appears only one time in a table, may appear multiple times in a related table.

Data staging consists of all of the following steps, EXCEPT ________.

The information in a data mart spans an entire enterprise.

A data dictionary is also referred to as a(n)________.

________ is the branch of computer science that attempts to create computers that think like humans.

Data ________ helps to ensure data integrity by maintaining information in only one place.

________ involves putting data into an electronic file in a format that another application can recognize.

Most databases can import electronic data from other software applications.

When creating a data warehouse, ________ is the process that extracts data from source databases, reformats the data, and stores them in the warehouse.

The data in a data warehouse are ________, meaning they do not all pertain to one period in time.