Question 1

In a database, another term for a table is a(n) ________.

Accepted Answer

The answer of In a database, another term for a...

Question 2

In a relational database, when two tables have a common field, the link between the tables is known as a hyperlink.

Accepted Answer

A) True 
 B)False

Question 3

In a Microsoft Access database, an active web page, e-mail address, or existing file is stored as a(n) ________ field.

Accepted Answer

The answer of In a Microsoft Access database, an active...

Question 4

The data in a data warehouse is ________, meaning it does not all pertain to one period in time.

Accepted Answer

The answer of The data in a data warehouse is...

Question 5

Most databases can import electronic data from other software applications.

Accepted Answer

A) True 
 B)False

Question 6

________ databases are better than relational databases at handling unstructured data such as audio clips, video clips, and pictures.

Accepted Answer

The answer of ________ databases are better than relational databases...

Question 7

A data dictionary is also referred to as a(n) ________.

Accepted Answer

The answer of A data dictionary is also referred to...

Question 8

________ is used to analyze large amounts of data and identify unseen patterns or trends.

Accepted Answer

The answer of ________ is used to analyze large amounts...

Question 9

When creating a data warehouse, ________ is the process that extracts data from source databases, reformats the data, and stores them in the warehouse.

Accepted Answer

The answer of When creating a data warehouse, ________ is...

Question 10

In a database, a group of related records is referred to as a(n) ________.

Accepted Answer

A)  memo 
B)  field 
C)  object 
D)  table

Question 11

When using Access, the text of the Declaration of Independence would be stored in a short text field.

Accepted Answer

A) True 
 B)False

Question 12

Match between columns
                        Premises: data mart
expert system
data staging
data mining
artificial intelligence

Accepted Answer

The Answer of process by which great amounts of data is...

Question 13

In a database, the term ________ is synonymous with a category of data.

Accepted Answer

A)  field 
B)  record 
C)  row 
D)  table

Question 14

Data that describes other data is called ________.

Accepted Answer

The answer of Data that describes other data is called...

Question 15

Data mining analyzes and investigates large amounts of data with the intention of discovering significant patterns or trends.

Accepted Answer

A) True 
 B)False

Question 16

Which of the following is a likely primary key in a student information record?

Accepted Answer

A)  Last name 
B)  Date of birth 
C)  Student ID number 
D)  First name

Question 17

A(n) ________ check determines whether a required field such as LastName was filled in.

Accepted Answer

A)  completeness 
B)  range 
C)  consistency 
D)  alphabetic

Question 18

A(n) ________ is created from a large data business warehouse to analyze a single component of the business.

Accepted Answer

The answer of A(n) ________ is created from a large...

Question 19

A field ________ is a property that must be met before an entry can be accepted into the field.

Accepted Answer

The answer of A field ________ is a property that...

Question 20

Real-time processing means that transactions are updated when they occur.

Accepted Answer

A) True 
 B)False

Exam 11: Behind the Scenes: Databases and Information Systems

In a database, another term for a table is a(n) ________.

In a relational database, when two tables have a common field, the link between the tables is known as a hyperlink.

In a Microsoft Access database, an active web page, e-mail address, or existing file is stored as a(n) ________ field.

The data in a data warehouse is ________, meaning it does not all pertain to one period in time.

Most databases can import electronic data from other software applications.

________ databases are better than relational databases at handling unstructured data such as audio clips, video clips, and pictures.

A data dictionary is also referred to as a(n) ________.

________ is used to analyze large amounts of data and identify unseen patterns or trends.

When creating a data warehouse, ________ is the process that extracts data from source databases, reformats the data, and stores them in the warehouse.

In a database, a group of related records is referred to as a(n) ________.

When using Access, the text of the Declaration of Independence would be stored in a short text field.

Match each of the following terms to its definition

In a database, the term ________ is synonymous with a category of data.

Data that describes other data is called ________.

Data mining analyzes and investigates large amounts of data with the intention of discovering significant patterns or trends.

Which of the following is a likely primary key in a student information record?

A(n) ________ check determines whether a required field such as LastName was filled in.

A(n) ________ is created from a large data business warehouse to analyze a single component of the business.

A field ________ is a property that must be met before an entry can be accepted into the field.

Real-time processing means that transactions are updated when they occur.