Exam 4: Managing Information Resources with Databases

Building interfaces or bridges between different databases to link common fields, is an integration strategy.

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

What is the drawback of using Social Security Number (SSN) as the primary keys for tables of employees, hospital patients, students, and even cable TV customers?

Retrieval is very fast through data cubes because ________.

An attribute of an entity is called a(n) ________.

Databases in which people outside the enterprise enter and manage most of the records are called ________.

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

Aban Constructions Limited, a construction company, maintains its records in rows within tables, and the tables are interconnected by linking the matching fields. Which type of database architecture does Aban Constructions Limited use?

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

In a clinic, each visiting physician maintains a spreadsheet with the name, work phone number, mobile number, and email of the clients. These individual spreadsheets are then compiled into one sheet. This would be an example of which type of information?

Which of the following is a disadvantage of using shadow systems?

A blog with a title, subtitle, content with date of creation, and a few images can be considered an example of semi-structured information.

A foreign key is ________.

A system's ability to handle rapidly increasing demand is called ________.

While generating payroll checks, the payroll department's computer programs read each record in the file and print out checks and payroll stubs for each person using the information contained in the files for that department. This is an example of data integration.

Structured information can be defined as data ________.

Which database resembles an organizational chart or an upside down tree, with the root record the company itself and the departments the root's child records?

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

A marketing representative, who wants to put the most positive spin on a tally of recent orders, chooses to include ones that have been canceled. This is an example of high-quality data.

How did Cuong Do manage the sudden explosion of visitors to YouTube?