Question 1

Which of the following refers to the procedures that keep data current?

Accepted Answer

A)  file maintenance 
B)  authentication integrity 
C)  data validation 
D)  information checking 
A)  file maintenance 
B)  authentication integrity 
C)  data validation 
D)  information checking

Question 2

A web database usually resides on a database server.

Accepted Answer

A) True 
 B)False

Question 3

COGNITIVE ASSESSMENT Which of the following contains a database that helps a group or department make decisions?

Accepted Answer

A)  data speedset 
B)  data mart 
C)  data warehouse 
D)  data market 
A)  data speedset 
B)  data mart 
C)  data warehouse 
D)  data market

Question 4

With a(n) ____________________, users create a computerized database; add, change, and delete data in the database; sort and retrieve data from the database; and create forms and reports from the data in the database.

Accepted Answer

database m

Question 5

Metadata describes the widespread growth of data, the variety of formats in which this data is available, and the processing required to make this data accessible in a timely manner.

Accepted Answer

A) True 
 B)False

Question 6

Check digits are the only type of validity check that is not able to validate data accuracy.

Accepted Answer

A) True 
 B)False

Question 7

Most of this kind of database products for servers and mainframes include SQL, an example of which is shown in the accompanying figure. What kind of database product is this?

Accepted Answer

A)  relational 
B)  object-oriented 
C)  multidimensional 
D)  file processing 
A)  relational 
B)  object-oriented 
C)  multidimensional 
D)  file processing

Question 8

Whereas a relational database can store more than two dimensions, a multidimensional database is a two-dimensional table.

Accepted Answer

A) True 
 B)False

Question 9

Explain data validation and the various types of validity checks.

Accepted Answer

Student responses will vary, but should

Question 10

The developer of a relational database refers to a field as which of the following?

Accepted Answer

A)  tuple 
B)  attribute 
C)  key 
D)  relation 
A)  tuple 
B)  attribute 
C)  key 
D)  relation

Question 11

COGNITIVE ASSESSMENT Which of the following manages information about customers, past purchases, interests, and the day-to-day interactions, such as phone calls, email messages, web communications, and instant messaging sessions?

Accepted Answer

A)  SFA 
B)  MRP 
C)  CAM 
D)  CRM 
A)  SFA 
B)  MRP 
C)  CAM 
D)  CRM

Question 12

It often is easier and faster to develop programs that use the database approach.

Accepted Answer

A) True 
 B)False

Question 13

COGNITIVE ASSESSMENT Which of the following statements about data types is not true?

Accepted Answer

A)  Yes/No fields can be used to create a field with True or False options. 
B)  AutoNumber data types assign numbers automatically to each record. 
C)  Text data types are used for lengthy memos. 
D)  Object data types are used for photos, audio, or video. 
A)  Yes/No fields can be used to create a field with True or False options. 
B)  AutoNumber data types assign numbers automatically to each record. 
C)  Text data types are used for lengthy memos. 
D)  Object data types are used for photos, audio, or video.

Question 14

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

Accepted Answer

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

Question 15

Which of the following identifies the quality of data in a database?

Accepted Answer

A)  file resolution 
B)  authenticated access 
C)  information dimensionality 
D)  data integrity 
A)  file resolution 
B)  authenticated access 
C)  information dimensionality 
D)  data integrity

Question 16

Which of the following is a database that stores data in tables that consist of rows and columns?

Accepted Answer

A)  object-oriented 
B)  tabular 
C)  relational 
D)  attribute-based 
A)  object-oriented 
B)  tabular 
C)  relational 
D)  attribute-based

Question 17

With the database approach, most data items are stored in multiple files, which greatly reduces duplicate data.

Accepted Answer

A) True 
 B)False

Question 18

COGNITIVE ASSESSMENT Which of the following is true about the database approach?

Accepted Answer

A)  Data in a database is less vulnerable than data in file processing systems. 
B)  Unauthorized users are unable under any circumstances to gain access to a single database file that contains personal and confidential data. 
C)  Business and home users often work with databases because of their numerous advantages. 
D)  A database is never more complex than a file processing system. 
A)  Data in a database is less vulnerable than data in file processing systems. 
B)  Unauthorized users are unable under any circumstances to gain access to a single database file that contains personal and confidential data. 
C)  Business and home users often work with databases because of their numerous advantages. 
D)  A database is never more complex than a file processing system.

Question 19

The developer of a relational database refers to a record as which of the following?

Accepted Answer

A)  tuple 
B)  field 
C)  attribute 
D)  relation 
A)  tuple 
B)  field 
C)  attribute 
D)  relation

Question 20

COGNITIVE ASSESSMENT Which of the following is not considered a part of file maintenance?

Accepted Answer

A)  adding a record to a database 
B)  modifying data in a record 
C)  the creation of a new database 
D)  deleting records from a database 
A)  adding a record to a database 
B)  modifying data in a record 
C)  the creation of a new database 
D)  deleting records from a database

Which of the following refers to the procedures that keep data current?

A web database usually resides on a database server.

COGNITIVE ASSESSMENT Which of the following contains a database that helps a group or department make decisions?

With a(n) ____________________, users create a computerized database; add, change, and delete data in the database; sort and retrieve data from the database; and create forms and reports from the data in the database.

Metadata describes the widespread growth of data, the variety of formats in which this data is available, and the processing required to make this data accessible in a timely manner.

Check digits are the only type of validity check that is not able to validate data accuracy.

Most of this kind of database products for servers and mainframes include SQL, an example of which is shown in the accompanying figure. What kind of database product is this?

Whereas a relational database can store more than two dimensions, a multidimensional database is a two-dimensional table.

Explain data validation and the various types of validity checks.

The developer of a relational database refers to a field as which of the following?

COGNITIVE ASSESSMENT Which of the following manages information about customers, past purchases, interests, and the day-to-day interactions, such as phone calls, email messages, web communications, and instant messaging sessions?

It often is easier and faster to develop programs that use the database approach.

COGNITIVE ASSESSMENT Which of the following statements about data types is not true?

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

Which of the following identifies the quality of data in a database?

Which of the following is a database that stores data in tables that consist of rows and columns?

With the database approach, most data items are stored in multiple files, which greatly reduces duplicate data.

COGNITIVE ASSESSMENT Which of the following is true about the database approach?

The developer of a relational database refers to a record as which of the following?

COGNITIVE ASSESSMENT Which of the following is not considered a part of file maintenance?

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

Which of the following refers to the procedures that keep data current?

A web database usually resides on a database server.

COGNITIVE ASSESSMENT Which of the following contains a database that helps a group or department make decisions?

With a(n) ____________________, users create a computerized database; add, change, and delete data in the database; sort and retrieve data from the database; and create forms and reports from the data in the database.

Metadata describes the widespread growth of data, the variety of formats in which this data is available, and the processing required to make this data accessible in a timely manner.

Check digits are the only type of validity check that is not able to validate data accuracy.

Most of this kind of database products for servers and mainframes include SQL, an example of which is shown in the accompanying figure. What kind of database product is this?

Whereas a relational database can store more than two dimensions, a multidimensional database is a two-dimensional table.

Explain data validation and the various types of validity checks.

The developer of a relational database refers to a field as which of the following?

COGNITIVE ASSESSMENT Which of the following manages information about customers, past purchases, interests, and the day-to-day interactions, such as phone calls, email messages, web communications, and instant messaging sessions?

It often is easier and faster to develop programs that use the database approach.

COGNITIVE ASSESSMENT Which of the following statements about data types is not true?

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

Which of the following identifies the quality of data in a database?

Which of the following is a database that stores data in tables that consist of rows and columns?

With the database approach, most data items are stored in multiple files, which greatly reduces duplicate data.

COGNITIVE ASSESSMENT Which of the following is true about the database approach?

The developer of a relational database refers to a record as which of the following?

COGNITIVE ASSESSMENT Which of the following is not considered a part of file maintenance?

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