Chapter 4 MIS quiz

________ is the term used to describe data collections that are characterized by huge volume, rapid velocity, and great variety (the three Vs).

Big Dat

A data integrity problem will occur only if ________.

data are duplicated in a database

Brad, a good-looking project manager, wants to build a database to integrate information about employees and tasks that they handle. Brad wants to track information such as task name, percentage completed, and employee name. These aspects that Brad wants to track are called ________.

entities

Most organizations develop their own DBMS software in order to obtain control over data.

false

Which of the following is true of MySQL?

it is license-free for most applications

A database is required instead of a spreadsheet when ________.

lists involve data with multiple themes

A data model is a ________.

logical representation of database data

Which of the following refers to the problem that exists in database applications when two users modify the same data item, but only one of those changes is recorded?

lost update problem

Albert creates a relational database to store employee performance statistics. He stores each employee's data in independent rows and creates a column named "Employee Number" to assign unique numbers to each employee. This column in the table is referred to as a(n) ________.

primary key

Brenda, the sales manager of a firm, wants to generate a particular report containing sales analyses of the second and third quarter of the year. She should use a ________ to obtain the information that she wants from the database.

query

The rows in a database are called ________.

records

A foreign key is essential in relational databases to represent the relationship between two tables.

true

Special data that describes the structure of a database is called metadata.

true