Question 1

In what kind of recovery does the DBMS use the log to undo any changes made to a database during a certain period?

Accepted Answer

A)  backward 
B)  restorative 
C)  undo 
D)  model 
A)  backward 
B)  restorative 
C)  undo 
D)  model

Question 2

In a rollforward, the DBMS uses the log to undo any changes made to the database during a certain period.

Accepted Answer

A) True 
 B)False

Question 3

COGNITIVE ASSESSMENT What is DBMS?

Accepted Answer

A)  a file 
B)  information 
C)  software 
D)  a device 
A)  a file 
B)  information 
C)  software 
D)  a device

Question 4

COGNITIVE ASSESSMENT Which of the following does not improve with the database approach?

Accepted Answer

A)  data integrity 
B)  data sharing 
C)  access 
D)  data security 
A)  data integrity 
B)  data sharing 
C)  access 
D)  data security

Question 5

COGNITIVE ASSESSMENT Which statement is not a recognized guideline for designing a database?

Accepted Answer

A)  Each table or file should contain data about one subject. 
B)  Create fields for every piece of data you might need, such as fields for Date and Age. 
C)  Every record needs a primary key. 
D)  Use separate fields for logically distinct items, such as First Name and Last Name. 
A)  Each table or file should contain data about one subject. 
B)  Create fields for every piece of data you might need, such as fields for Date and Age. 
C)  Every record needs a primary key. 
D)  Use separate fields for logically distinct items, such as First Name and Last Name.

Question 6

In managing a company's database, which of the following roles requires a technical inside view of data?

Accepted Answer

A)  administrator 
B)  manager 
C)  modeler 
D)  leader 
A)  administrator 
B)  manager 
C)  modeler 
D)  leader

Question 7

Key fields link data together in a database.

Accepted Answer

A) True 
 B)False

Question 8

Which of the following kinds of values is the one that a DBMS initially displays in a field?

Accepted Answer

A)  query 
B)  start 
C)  initial 
D)  default 
A)  query 
B)  start 
C)  initial 
D)  default

Question 9

COGNITIVE ASSESSMENT After a power failure, you instruct the DBMS to use the log to reenter any changes made to the database since the last save or backup. What term is used to describe this backup technique?

Accepted Answer

A)  restoration principle 
B)  forward recovery 
C)  continuous backup 
D)  rollback 
A)  restoration principle 
B)  forward recovery 
C)  continuous backup 
D)  rollback

Question 10

Verifiable information can be proven as correct or incorrect.

Accepted Answer

A) True 
 B)False

Question 11

A user cannot override the default value.

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

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

Question 13

Explain a multidimensional database, its applications, and its main advantage.

Accepted Answer

Student responses will vary, but should

Question 14

To access data in a(n) ____________________ database, users fill in an e-form or enter search text on a webpage.

Accepted Answer

The answer of To access data in a(n) ____________________ database,...

Question 15

An application that supports a front-end program sometimes is called which of the following?

Accepted Answer

A)  back end 
B)  RDBMS 
C)  GUI 
D)  collaborative database 
A)  back end 
B)  RDBMS 
C)  GUI 
D)  collaborative database

Question 16

A common reason to change a record is to update old data with new data.

Accepted Answer

A) True 
 B)False

Question 17

____________________ is a computer phrase that points out that the accuracy of a computer's output depends on the accuracy of its input.

Accepted Answer

The answer of ____________________ is a computer phrase that points...

Question 18

COGNITIVE ASSESSMENT In a database, what is the smallest unit of data a user accesses?

Accepted Answer

A)  a field 
B)  a character 
C)  a record 
D)  a file 
A)  a field 
B)  a character 
C)  a record 
D)  a file

Question 19

In the ASCII coding scheme, each byte represents a single ____________________, which can be a number, letter, space, punctuation mark, or other symbol.

Accepted Answer

The answer of In the ASCII coding scheme, each byte...

Question 20

A file is a group of related fields.

Accepted Answer

A) True 
 B)False

In what kind of recovery does the DBMS use the log to undo any changes made to a database during a certain period?

In a rollforward, the DBMS uses the log to undo any changes made to the database during a certain period.

COGNITIVE ASSESSMENT What is DBMS?

COGNITIVE ASSESSMENT Which of the following does not improve with the database approach?

COGNITIVE ASSESSMENT Which statement is not a recognized guideline for designing a database?

In managing a company's database, which of the following roles requires a technical inside view of data?

Key fields link data together in a database.

Which of the following kinds of values is the one that a DBMS initially displays in a field?

COGNITIVE ASSESSMENT After a power failure, you instruct the DBMS to use the log to reenter any changes made to the database since the last save or backup. What term is used to describe this backup technique?

Verifiable information can be proven as correct or incorrect.

A user cannot override the default value.

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

Explain a multidimensional database, its applications, and its main advantage.

To access data in a(n) ____________________ database, users fill in an e-form or enter search text on a webpage.

An application that supports a front-end program sometimes is called which of the following?

A common reason to change a record is to update old data with new data.

____________________ is a computer phrase that points out that the accuracy of a computer's output depends on the accuracy of its input.

COGNITIVE ASSESSMENT In a database, what is the smallest unit of data a user accesses?

In the ASCII coding scheme, each byte represents a single ____________________, which can be a number, letter, space, punctuation mark, or other symbol.

A file is a group of related fields.

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

In what kind of recovery does the DBMS use the log to undo any changes made to a database during a certain period?

In a rollforward, the DBMS uses the log to undo any changes made to the database during a certain period.

COGNITIVE ASSESSMENT What is DBMS?

COGNITIVE ASSESSMENT Which of the following does not improve with the database approach?

COGNITIVE ASSESSMENT Which statement is not a recognized guideline for designing a database?

In managing a company's database, which of the following roles requires a technical inside view of data?

Key fields link data together in a database.

Which of the following kinds of values is the one that a DBMS initially displays in a field?

COGNITIVE ASSESSMENT After a power failure, you instruct the DBMS to use the log to reenter any changes made to the database since the last save or backup. What term is used to describe this backup technique?

Verifiable information can be proven as correct or incorrect.

A user cannot override the default value.

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

Explain a multidimensional database, its applications, and its main advantage.

To access data in a(n) ____________________ database, users fill in an e-form or enter search text on a webpage.

An application that supports a front-end program sometimes is called which of the following?

A common reason to change a record is to update old data with new data.

____________________ is a computer phrase that points out that the accuracy of a computer's output depends on the accuracy of its input.

COGNITIVE ASSESSMENT In a database, what is the smallest unit of data a user accesses?

In the ASCII coding scheme, each byte represents a single ____________________, which can be a number, letter, space, punctuation mark, or other symbol.

A file is a group of related fields.

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