Question 1

The field in a table that is used to relate that table to other tables is called the ____.

Accepted Answer

A)  composite key 
B)  secondary key 
C)  primary key 
D)  primary field 
A)  composite key 
B)  secondary key 
C)  primary key 
D)  primary field

Question 2

In some systems, data integrity is enforced on a per transaction basis.

Accepted Answer

A) True 
 B)False

Question 3

Repairing or restoring data that has become corrupt, perhaps as the result of a storage media error or computer virus, is a database analysis activity.

Accepted Answer

A) True 
 B)False

Question 4

With HOLAP (Hybrid OLAP), a combination of MOLAP and ROLAP technologies are used.

Accepted Answer

A) True 
 B)False

Question 5

If a field needs to store decimal places, the Long Integer field size can be used.

Accepted Answer

A) True 
 B)False

Question 6

____________________ script is a set of instructions written in a programming language and designed to accept data from and return data to a Web page visitor.

Accepted Answer

The answer of ____________________ script is a set of instructions...

Question 7

Many-to-many entity relationships exist when one entity can be related to more than one other entity, and those entities can be related to multiple entities of the same type as the original entity.

Accepted Answer

A) True 
 B)False

Question 8

Individual database tables are often referred to as ____.

Accepted Answer

A)  low files 
B)  base files 
C)  flat files 
D)  clear files 
A)  low files 
B)  base files 
C)  flat files 
D)  clear files

Question 9

Arranging data for efficient retrieval is called data organization.

Accepted Answer

A) True 
 B)False

Question 10

Multidimensional databases are appropriate when a variety of types of objects need to be stored and retrieved.

Accepted Answer

A) True 
 B)False

Question 11

The data dictionary includes data located in the database tables.

Accepted Answer

A) True 
 B)False

Question 12

Data integrity refers to the accuracy of data.

Accepted Answer

A) True 
 B)False

Question 13

Hashing procedures usually result in two or more records being assigned the same storage address, an event known as a collision.

Accepted Answer

A) True 
 B)False

Question 14

The process of evaluating and correcting the structures of the tables in a database to minimize data redundancy is called ____________________.

Accepted Answer

The answer of The process of evaluating and correcting the...

Question 15

Primary keys can be a combination of two key fields (called ____________________ primary keys), but single primary keys are more typical in simple databases.

Accepted Answer

The answer of Primary keys can be a combination of...

Question 16

A record is also called a ____.

Accepted Answer

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

Question 17

Normalization is usually viewed as a multistep process, from first normal form (1NF) to usually fifth normal form (5NF).

Accepted Answer

A) True 
 B)False

Question 18

A database typically consists of interrelated tables that contain forms and reports.

Accepted Answer

A) True 
 B)False

Question 19

The process of evaluating and correcting the structures of the tables in a database to minimize data redundancy is called ____.

Accepted Answer

A)  normalization 
B)  cyclic redundancy check 
C)  zeroing 
D)  zonification 
A)  normalization 
B)  cyclic redundancy check 
C)  zeroing 
D)  zonification

Question 20

Discuss database entities and attributes.

Accepted Answer

An entity is something (such as a person

The field in a table that is used to relate that table to other tables is called the ____.

In some systems, data integrity is enforced on a per transaction basis.

Repairing or restoring data that has become corrupt, perhaps as the result of a storage media error or computer virus, is a database analysis activity.

With HOLAP (Hybrid OLAP), a combination of MOLAP and ROLAP technologies are used.

If a field needs to store decimal places, the Long Integer field size can be used.

____________________ script is a set of instructions written in a programming language and designed to accept data from and return data to a Web page visitor.

Many-to-many entity relationships exist when one entity can be related to more than one other entity, and those entities can be related to multiple entities of the same type as the original entity.

Individual database tables are often referred to as ____.

Arranging data for efficient retrieval is called data organization.

Multidimensional databases are appropriate when a variety of types of objects need to be stored and retrieved.

The data dictionary includes data located in the database tables.

Data integrity refers to the accuracy of data.

Hashing procedures usually result in two or more records being assigned the same storage address, an event known as a collision.

The process of evaluating and correcting the structures of the tables in a database to minimize data redundancy is called ____________________.

Primary keys can be a combination of two key fields (called ____________________ primary keys), but single primary keys are more typical in simple databases.

A record is also called a ____.

Normalization is usually viewed as a multistep process, from first normal form (1NF) to usually fifth normal form (5NF).

A database typically consists of interrelated tables that contain forms and reports.

The process of evaluating and correcting the structures of the tables in a database to minimize data redundancy is called ____.

Discuss database entities and attributes.

Introduction to the World of Computers

The System Unit: Processing and Memory

Storage

Input and Output

System Software: Operating Systems and Utility

Application Software

Computer Networks

The Internet and the World Wide Web

Network and Internet Security

Multimedia and the Web

E-Commerce

Information Systems and System Development

Program Development and Programming Languages

Computer Security and Privacy

Intellectual Property Rights, Ethics, Health, Acccess and the Environment

Filters

Exam 14: Databases and Database Management Systems

The field in a table that is used to relate that table to other tables is called the ____.

In some systems, data integrity is enforced on a per transaction basis.

Repairing or restoring data that has become corrupt, perhaps as the result of a storage media error or computer virus, is a database analysis activity.

With HOLAP (Hybrid OLAP), a combination of MOLAP and ROLAP technologies are used.

If a field needs to store decimal places, the Long Integer field size can be used.

____________________ script is a set of instructions written in a programming language and designed to accept data from and return data to a Web page visitor.

Many-to-many entity relationships exist when one entity can be related to more than one other entity, and those entities can be related to multiple entities of the same type as the original entity.

Individual database tables are often referred to as ____.

Arranging data for efficient retrieval is called data organization.

Multidimensional databases are appropriate when a variety of types of objects need to be stored and retrieved.

The data dictionary includes data located in the database tables.

Data integrity refers to the accuracy of data.

Hashing procedures usually result in two or more records being assigned the same storage address, an event known as a collision.

The process of evaluating and correcting the structures of the tables in a database to minimize data redundancy is called ____________________.

Primary keys can be a combination of two key fields (called ____________________ primary keys), but single primary keys are more typical in simple databases.

A record is also called a ____.

Normalization is usually viewed as a multistep process, from first normal form (1NF) to usually fifth normal form (5NF).

A database typically consists of interrelated tables that contain forms and reports.

The process of evaluating and correcting the structures of the tables in a database to minimize data redundancy is called ____.

Discuss database entities and attributes.

Introduction to the World of Computers

The System Unit: Processing and Memory

Storage

Input and Output

System Software: Operating Systems and Utility

Application Software

Computer Networks

The Internet and the World Wide Web

Network and Internet Security

Multimedia and the Web

E-Commerce

Information Systems and System Development

Program Development and Programming Languages

Computer Security and Privacy

Intellectual Property Rights, Ethics, Health, Acccess and the Environment

Filters