Exam 4: Databases and DataWarehouses

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

In an organization, each employee might work for one or more projects, as well as for different managers. In such a case, the best approach by a database manager would be to create multiple records for the employee.

While creating a relational database for an organization, "Employees" would constitute one attribute with employee ID number, last name, first name, birth date, email address, and phone number as entities.

The process by which users are directed to a copy of the database when the main one fails is called ________.

A company maintains a centralized repository of information from internal sources, competitor information, census reports, and metadata from documents and multimedia. This is known as a ________.

Describe the most common strategy for creating a data warehouse.

The data collected by online pop-up surveys can be considered to be high-quality data.

________ is a prepackaged data warehouse solution offered by vendors that includes the hardware and software, maintenance, and support.

Structured query language is a standard query language ________.

What is SQL?

In comparison with unstructured information, semi-structured information ________.

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 ________.

When a user clicks "SUBMIT" on a web-based survey, the record is inserted into the database through an SQL command.

A blog with a title, subtitle, content with date of creation, and a few images exemplifies semi-structured information.

Which of the following is a function of normalization?

Database developers should use meaningful information for primary keys.

The process of retrieving data from multiple sources to be loaded into a data warehouse is called ________.

Which of the following is the best way to handle complex relationships, such as the data for a company where employees can be assigned to more than one project, and each project can have more than one employee assigned to it?

________ specifies the characteristics of a field, such as the type of data it will hold.

When building a warehouse, the process of reformatting data so that it conforms to set standards is called ________.