Question 1

A(n) ____________________ verifies that a required field contains data.

Accepted Answer

The answer of A(n) ____________________ verifies that a required field...

Question 2

Some report generators allow you to create a webpage, which can be interactive.

Accepted Answer

A) True 
 B)False

Question 3

Materials Requirements Planning controls production equipment, such as drills, lathes, and milling machines.

Accepted Answer

A) True 
 B)False

Question 4

A database eliminates redundant data.

Accepted Answer

A) True 
 B)False

Question 5

Which of the following is a process designed to ensure the data within the relations (tables) contains the least amount of duplication?

Accepted Answer

A)  concatenation 
B)  rasterization 
C)  dithering 
D)  normalization 
A)  concatenation 
B)  rasterization 
C)  dithering 
D)  normalization

Question 6

When a(n) ____________________ no longer is needed, a user deletes it from a file.

Accepted Answer

The answer of When a(n) ____________________ no longer is needed,...

Question 7

Which of the following is true in a relational database?

Accepted Answer

A)  Each row and each column has a primary key. 
B)  Each row has a unique name and each column has a primary key. 
C)  Each row has a primary key and each column has a unique name. 
D)  Each row and each column has a unique name. 
A)  Each row and each column has a primary key. 
B)  Each row has a unique name and each column has a primary key. 
C)  Each row has a primary key and each column has a unique name. 
D)  Each row and each column has a unique name.

Question 8

COGNITIVE ASSESSMENT Which term describes a huge database that stores and manages data required to analyze historical and current transactions?

Accepted Answer

A)  data mine 
B)  data archive 
C)  data market 
D)  data warehouse 
A)  data mine 
B)  data archive 
C)  data market 
D)  data warehouse

Question 9

COGNITIVE ASSESSMENT Which of the following statements best describes a form?

Accepted Answer

A)  a window on the screen that provides areas for entering or modifying data in a database 
B)  a formatted, printable retrieval of specific data 
C)  a screen that enables a database user to add or delete tables 
D)  the opening screen in a DBMS in which the user logs in to achieve authorization to modify or retrieve data 
A)  a window on the screen that provides areas for entering or modifying data in a database 
B)  a formatted, printable retrieval of specific data 
C)  a screen that enables a database user to add or delete tables 
D)  the opening screen in a DBMS in which the user logs in to achieve authorization to modify or retrieve data

Question 10

COGNITIVE ASSESSMENT Which of the following statements is not true about object-oriented databases (OODBs)?

Accepted Answer

A)  A voice mail system is an example of a groupware database. 
B)  An object is an item that contains data, as well as the actions that read or process the data. 
C)  An OODB stores unstructured data more efficiently than a relational database. 
D)  OODBs can store more types of data and access it faster than relational databases. 
A)  A voice mail system is an example of a groupware database. 
B)  An object is an item that contains data, as well as the actions that read or process the data. 
C)  An OODB stores unstructured data more efficiently than a relational database. 
D)  OODBs can store more types of data and access it faster than relational databases.

Question 11

The data modeler creates and maintains the data dictionary, manages security of the database, monitors the performance of the database, and checks backup and recovery procedures.

Accepted Answer

A) True 
 B)False

Question 12

____________________ information has meaning to the person who receives it.

Accepted Answer

The answer of ____________________ information has meaning to the person...

Question 13

What is a data type? List the data types commonly found in a database.

Accepted Answer

Student responses will vary, but should

Question 14

____________________ is a common data type that consists of lengthy text entries.

Accepted Answer

The answer of ____________________ is a common data type that...

Question 15

A user of a database such as that pictured in the accompanying figure refers to a record as what?

Accepted Answer

A)  table 
B)  column 
C)  row 
D)  relationship 
A)  table 
B)  column 
C)  row 
D)  relationship

Question 16

COGNITIVE ASSESSMENT What is the term for the process of comparing data with a set of rules or values to find out if the data is correct?

Accepted Answer

A)  query 
B)  verification 
C)  procedure 
D)  validation 
A)  query 
B)  verification 
C)  procedure 
D)  validation

Question 17

Each higher level of data consists of one or more items from the lower level.

Accepted Answer

A) True 
 B)False

Question 18

Which of the following is a program with which users interact that generally has a more user-friendly interface than a DBMS?

Accepted Answer

A)  back end 
B)  RDBMS 
C)  SQL 
D)  front end 
A)  back end 
B)  RDBMS 
C)  SQL 
D)  front end

Question 19

Which of the following is an advantage of a multidimensional database?

Accepted Answer

A)  There is a common query language. 
B)  The content of all dimensions is the same regardless of the subject. 
C)  It can consolidate data much faster than a relational database. 
D)  All multidimensional databases have a dimension of time. 
A)  There is a common query language. 
B)  The content of all dimensions is the same regardless of the subject. 
C)  It can consolidate data much faster than a relational database. 
D)  All multidimensional databases have a dimension of time.

Question 20

COGNITIVE ASSESSMENT Which of the following statements is not true about multidimensional databases?

Accepted Answer

A)  The number of dimensions in a multidimensional database varies. 
B)  Most multidimensional databases use a standard query language. 
C)  Nearly every multidimensional database has a dimension of time. 
D)  A multidimensional database can consolidate data much faster than a relational database. 
A)  The number of dimensions in a multidimensional database varies. 
B)  Most multidimensional databases use a standard query language. 
C)  Nearly every multidimensional database has a dimension of time. 
D)  A multidimensional database can consolidate data much faster than a relational database.

A(n) ____________________ verifies that a required field contains data.

Some report generators allow you to create a webpage, which can be interactive.

Materials Requirements Planning controls production equipment, such as drills, lathes, and milling machines.

A database eliminates redundant data.

Which of the following is a process designed to ensure the data within the relations (tables) contains the least amount of duplication?

When a(n) ____________________ no longer is needed, a user deletes it from a file.

Which of the following is true in a relational database?

COGNITIVE ASSESSMENT Which term describes a huge database that stores and manages data required to analyze historical and current transactions?

COGNITIVE ASSESSMENT Which of the following statements best describes a form?

COGNITIVE ASSESSMENT Which of the following statements is not true about object-oriented databases (OODBs)?

The data modeler creates and maintains the data dictionary, manages security of the database, monitors the performance of the database, and checks backup and recovery procedures.

____________________ information has meaning to the person who receives it.

What is a data type? List the data types commonly found in a database.

____________________ is a common data type that consists of lengthy text entries.

A user of a database such as that pictured in the accompanying figure refers to a record as what?

COGNITIVE ASSESSMENT What is the term for the process of comparing data with a set of rules or values to find out if the data is correct?

Each higher level of data consists of one or more items from the lower level.

Which of the following is a program with which users interact that generally has a more user-friendly interface than a DBMS?

Which of the following is an advantage of a multidimensional database?

COGNITIVE ASSESSMENT Which of the following statements is not true about multidimensional databases?

Digital Literacy

The Internet

Computers and Mobile Devices

Programs and Apps

Digital Safety and Security

Inside Computers and Mobile Devices

Input and Output

Digital Storage

Operating Systems

Communications and Networks

Information Systems and Program Development

Appendix: Discovering Computers

Filters

Exam 11: Information and Data Management

A(n) ____________________ verifies that a required field contains data.

Some report generators allow you to create a webpage, which can be interactive.

Materials Requirements Planning controls production equipment, such as drills, lathes, and milling machines.

A database eliminates redundant data.

Which of the following is a process designed to ensure the data within the relations (tables) contains the least amount of duplication?

When a(n) ____________________ no longer is needed, a user deletes it from a file.

Which of the following is true in a relational database?

COGNITIVE ASSESSMENT Which term describes a huge database that stores and manages data required to analyze historical and current transactions?

COGNITIVE ASSESSMENT Which of the following statements best describes a form?

COGNITIVE ASSESSMENT Which of the following statements is not true about object-oriented databases (OODBs)?

The data modeler creates and maintains the data dictionary, manages security of the database, monitors the performance of the database, and checks backup and recovery procedures.

____________________ information has meaning to the person who receives it.

What is a data type? List the data types commonly found in a database.

____________________ is a common data type that consists of lengthy text entries.

A user of a database such as that pictured in the accompanying figure refers to a record as what?

COGNITIVE ASSESSMENT What is the term for the process of comparing data with a set of rules or values to find out if the data is correct?

Each higher level of data consists of one or more items from the lower level.

Which of the following is a program with which users interact that generally has a more user-friendly interface than a DBMS?

Which of the following is an advantage of a multidimensional database?

COGNITIVE ASSESSMENT Which of the following statements is not true about multidimensional databases?

Digital Literacy

The Internet

Computers and Mobile Devices

Programs and Apps

Digital Safety and Security

Inside Computers and Mobile Devices

Input and Output

Digital Storage

Operating Systems

Communications and Networks

Information Systems and Program Development

Appendix: Discovering Computers

Filters