Question 1

COGNITIVE ASSESSMENT In your school's database, in which of the following is all of the information about a particular student stored?

Accepted Answer

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

Question 2

A DBMS uses which of the following to perform validation checks?

Accepted Answer

A)  data server 
B)  data mart 
C)  data warehouse 
D)  data dictionary 
A)  data server 
B)  data mart 
C)  data warehouse 
D)  data dictionary

Question 3

A checkout clerk with this level of privileges to the email addresses in a discount warehouse database could view the addresses but not change them. What is this level of privileges called?

Accepted Answer

A)  read-only 
B)  write-only 
C)  full-update 
D)  no access 
A)  read-only 
B)  write-only 
C)  full-update 
D)  no access

Question 4

COGNITIVE ASSESSMENT What is data redundancy?

Accepted Answer

A)  There is no primary key to distinguish records. 
B)  Each department has its own files, so the same data might be stored in multiple files. 
C)  Data is linked to multiple records in a database. 
D)  In the same database, each department enters data without checking to ensure it has not already been entered. 
A)  There is no primary key to distinguish records. 
B)  Each department has its own files, so the same data might be stored in multiple files. 
C)  Data is linked to multiple records in a database. 
D)  In the same database, each department enters data without checking to ensure it has not already been entered.

Question 5

In the database pictured in the accompanying figure, which of the following is a combination of one or more related characters or bytes and is the smallest unit of data a user accesses?

Accepted Answer

A)  field 
B)  member 
C)  record 
D)  identifier 
A)  field 
B)  member 
C)  record 
D)  identifier

Question 6

Like a form, a report generator is used to maintain and retrieve data.

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

A)  concatenation 
B)  validation 
C)  digit checking 
D)  integration 
A)  concatenation 
B)  validation 
C)  digit checking 
D)  integration

Question 8

Many database programs perform which of the following in order to analyze entered data to help ensure that it is correct?

Accepted Answer

A)  information confirmation 
B)  integration 
C)  validity check 
D)  integrity valuation 
A)  information confirmation 
B)  integration 
C)  validity check 
D)  integrity valuation

Question 9

COGNITIVE ASSESSMENT Which term is used to describe the practice that users' access privileges are limited to the lowest level necessary to perform required tasks?

Accepted Answer

A)  theory of restriction 
B)  principle of least privilege 
C)  hierarchy of administration 
D)  protocol of access 
A)  theory of restriction 
B)  principle of least privilege 
C)  hierarchy of administration 
D)  protocol of access

Question 10

Discuss three applications appropriate for an object-oriented database.

Accepted Answer

Student responses will vary, but should

Question 11

Which of the following is a huge database that stores and manages the data required to analyze historical and current transactions?

Accepted Answer

A)  data stockyard 
B)  data warehouse 
C)  data storehouse 
D)  data storage unit 
A)  data stockyard 
B)  data warehouse 
C)  data storehouse 
D)  data storage unit

Question 12

Which of the following kind of checks is a validity check performed on data, like that in the accompanying figure, which ensures users enter only alphabetic data into a field?

Accepted Answer

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

Question 13

Data integrity is important because computers and people use information to make decisions and take actions.

Accepted Answer

A) True 
 B)False

Question 14

A relational database typically processes and summarizes large numbers of records efficiently.

Accepted Answer

A) True 
 B)False

Question 15

The data in a database is independent of programs that access that data.

Accepted Answer

A) True 
 B)False

Question 16

Which of the following consists of rules and standards that define how a database organizes data?

Accepted Answer

A)  data standard 
B)  data model 
C)  rules-based integration 
D)  object-relation 
A)  data standard 
B)  data model 
C)  rules-based integration 
D)  object-relation

Question 17

If the lowest annual fee at a discount warehouse is $20.25 and the highest is $55.50, a(n) ____________________ on the Annual Fee field ensures it is a value between $20.25 and $55.50.

Accepted Answer

The answer of If the lowest annual fee at a...

Question 18

In a relational database, where does the only data redundancy exist?

Accepted Answer

A)  in the hypermedia 
B)  in the fields 
C)  in the hypertext 
D)  in the relationships 
A)  in the hypermedia 
B)  in the fields 
C)  in the hypertext 
D)  in the relationships

Question 19

In what kind of recovery does the DBMS use the log to reenter changes made to a database since the last save or backup?

Accepted Answer

A)  instant 
B)  baseline 
C)  integrated 
D)  forward 
A)  instant 
B)  baseline 
C)  integrated 
D)  forward

Question 20

In a database, the data ____________________ specifies the kind of data a field can contain and how the field is used.

Accepted Answer

The answer of In a database, the data ____________________ specifies...

COGNITIVE ASSESSMENT In your school's database, in which of the following is all of the information about a particular student stored?

A DBMS uses which of the following to perform validation checks?

A checkout clerk with this level of privileges to the email addresses in a discount warehouse database could view the addresses but not change them. What is this level of privileges called?

COGNITIVE ASSESSMENT What is data redundancy?

In the database pictured in the accompanying figure, which of the following is a combination of one or more related characters or bytes and is the smallest unit of data a user accesses?

Like a form, a report generator is used to maintain and retrieve data.

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

Many database programs perform which of the following in order to analyze entered data to help ensure that it is correct?

COGNITIVE ASSESSMENT Which term is used to describe the practice that users' access privileges are limited to the lowest level necessary to perform required tasks?

Discuss three applications appropriate for an object-oriented database.

Which of the following is a huge database that stores and manages the data required to analyze historical and current transactions?

Which of the following kind of checks is a validity check performed on data, like that in the accompanying figure, which ensures users enter only alphabetic data into a field?

Data integrity is important because computers and people use information to make decisions and take actions.

A relational database typically processes and summarizes large numbers of records efficiently.

The data in a database is independent of programs that access that data.

Which of the following consists of rules and standards that define how a database organizes data?

If the lowest annual fee at a discount warehouse is $20.25 and the highest is $55.50, a(n) ____________________ on the Annual Fee field ensures it is a value between $20.25 and $55.50.

In a relational database, where does the only data redundancy exist?

In what kind of recovery does the DBMS use the log to reenter changes made to a database since the last save or backup?

In a database, the data ____________________ specifies the kind of data a field can contain and how the field is used.

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

COGNITIVE ASSESSMENT In your school's database, in which of the following is all of the information about a particular student stored?

A DBMS uses which of the following to perform validation checks?

A checkout clerk with this level of privileges to the email addresses in a discount warehouse database could view the addresses but not change them. What is this level of privileges called?

COGNITIVE ASSESSMENT What is data redundancy?

In the database pictured in the accompanying figure, which of the following is a combination of one or more related characters or bytes and is the smallest unit of data a user accesses?

Like a form, a report generator is used to maintain and retrieve data.

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

Many database programs perform which of the following in order to analyze entered data to help ensure that it is correct?

COGNITIVE ASSESSMENT Which term is used to describe the practice that users' access privileges are limited to the lowest level necessary to perform required tasks?

Discuss three applications appropriate for an object-oriented database.

Which of the following is a huge database that stores and manages the data required to analyze historical and current transactions?

Which of the following kind of checks is a validity check performed on data, like that in the accompanying figure, which ensures users enter only alphabetic data into a field?

Data integrity is important because computers and people use information to make decisions and take actions.

A relational database typically processes and summarizes large numbers of records efficiently.

The data in a database is independent of programs that access that data.

Which of the following consists of rules and standards that define how a database organizes data?

If the lowest annual fee at a discount warehouse is $20.25 and the highest is $55.50, a(n) ____________________ on the Annual Fee field ensures it is a value between $20.25 and $55.50.

In a relational database, where does the only data redundancy exist?

In what kind of recovery does the DBMS use the log to reenter changes made to a database since the last save or backup?

In a database, the data ____________________ specifies the kind of data a field can contain and how the field is used.

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