Exam 4: Databases and Datawarehouses

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

One goal of normalization is to ________.

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

Which product allows voice commands, sequenced like a natural conversation, as a means to access a database?

Describe the most common strategy for creating a data warehouse.

Structured query language is a standard query language ________.

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

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

While using a word processor to create a project report, Ashley includes the subject, title, and the author's name in the report's properties. What type of information is Ashley adding to her report?

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

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

One of the uses of databases without boundaries is in ________.

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

What is SQL?

Which process assigns incremental numbers to records as they are created to ensure that each record has a unique primary key?

A foreign key is ________.

A person who ensures that people adhere to the definitions for the master data in their organizational units is called a(n)________.

Pieces of information that cannot be linked together are called ________.

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

Roman Jade, an interior decorations company, stores employee details in its employee information system. The birth date of each employee is stored along with other details, including employee names. The relationship between the employee names and employee birth dates is a ________.