Exam 11: Behind the Scenes: Databases and Information Systems

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

Most databases can import electronic data from other software applications.

A(n) ________ database stores data in more than two dimensions, as opposed to relational databases, which store data in two-dimensional tables.

Referential integrity means that for each value in the ________ field of a table, there is a corresponding value in the primary key of the related table.

Management information systems (MIS) provide reports called ________ reports, which show conditions that are unusual or need attention from users of the system.

You can set a ________, which is automatically displayed in a field unless the user enters something different.

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

The Siri personal assistant application on Apple's iPhone 5s is an example of a ________.

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

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

When using SQL, a(n) ________ query is used to extract data from two or more tables.

Data ________ ensures that the data contained in a database is accurate and reliable.

An employee's ID number, name, company position, address, city, state, and Zip Code make up a record.

SQL uses ________ to extract records from a database by using English-like expressions that have variables and operations.

To temporarily display records from a single table that match certain criteria, you would use a(n) ________.

Which of the following is NOT a likely primary key?

The information in a data mart spans an entire enterprise.

A data ________ is a large-scale electronic repository of data that contains and organizes all of an organization's data in one place.

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

A last name field is an example of a field that should have a default value.