Databases and Information Management

A characteristic or quality that describes a particular database entity is called a(n):

• field.

• tuple.

• key field.

• attribute.

Data ________ occurs when the same data is duplicated in multiple files of a database.

• redundancy

• repetition

• independence

• partitions

Which of the following occurs when the same attribute in related data files has different values?

• Data redundancy

• Data duplication

• Data dependence

• Data inconsistency

A record is a group of related fields.

• True

• False

A(n) ________ represent data as two-dimensional tables.

• non-relational DBMS

• mobile DBMS

• relational DBMS

• hierarchical DBMS

A field identified in a table as holding the unique identifier of the table's records is called the:

• primary key.

• key field.

• primary field.

• unique ID.

You are creating a database to store temperature and wind data from various airports. Which of the following fields is the most likely candidate to use as the basis for a primary key in the Airport table?

• Address

• City

• Airport code

• Day

Which of the following technologies would you use to analyze the social media data collected by a major online retailer?

• Data warehouse

• Data mart

• Hadoop

• DBMS

Data mining allows users to:

• quickly compare transaction data gathered over many years.

• find hidden patterns, relationships in data.

• obtain online answers to ad-hoc questions in a rapid amount of time.

• summarize massive amounts of data into much smaller, traditional reports.

You can use text mining tools to analyze unstructured data, such as memos and email

• TRUE

• FALSE