Question 1

In a file processing system, each department or area in an organization shares files collectively.

Accepted Answer

A) True 
 B)False

Question 2

COGNITIVE ASSESSMENT If you are running a check to ensure that a required field contains data, or the correct minimum number of characters, what kind of check are you running?

Accepted Answer

A)  completeness 
B)  alphabetic 
C)  range 
D)  check digit 
A)  completeness 
B)  alphabetic 
C)  range 
D)  check digit

Question 3

Which of the following languages consists of simple, English-like statements that allow users to specify the data to display, print, or store?

Accepted Answer

A)  report 
B)  query 
C)  specification 
D)  inquiry 
A)  report 
B)  query 
C)  specification 
D)  inquiry

Question 4

Critical Thinking Questions Case 11-2
In your database course, your instructor has given you a small database that has a lot of invalid data, issuing the challenge to you that you work to apply validation rules to the data and determine what checks need to be applied in order to restore integrity to the data.
A quick scan of the data in the First Name field in the database yields the numbers 3 and 7 and an asterisk. What kind of check should you run on this field?

Accepted Answer

A)  completeness check 
B)  alphabetic check 
C)  consistency check 
D)  check digit 
A)  completeness check 
B)  alphabetic check 
C)  consistency check 
D)  check digit

Question 5

In a relational database, users can set up a relationship between tables at any time, but the tables must have a common row or field.

Accepted Answer

A) True 
 B)False

Question 6

Query by example uses a graphical user interface that assists users with retrieving data.

Accepted Answer

A) True 
 B)False

Question 7

As shown in the accompanying figure, which of the following is a query language that allows users to manage, update, and retrieve data?

Accepted Answer

A)  XML 
B)  DBMS 
C)  SQL 
D)  QBE 
A)  XML 
B)  DBMS 
C)  SQL 
D)  QBE

Question 8

For a computer to produce correct information, the data that is input into a database must have integrity.

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

A)  A relationship is a link within the data. 
B)  To set up a relationship between tables, they must have a common field. 
C)  Many organizations use relational databases for payroll, accounts receivable, order entry, and invoicing. 
D)  Applications best suited for relational databases are those whose data can be organized into a three-dimensional table. 
A)  A relationship is a link within the data. 
B)  To set up a relationship between tables, they must have a common field. 
C)  Many organizations use relational databases for payroll, accounts receivable, order entry, and invoicing. 
D)  Applications best suited for relational databases are those whose data can be organized into a three-dimensional table.

Question 10

COGNITIVE ASSESSMENT Which term does a user of a relational database use to refer to a file?

Accepted Answer

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

Question 11

COGNITIVE ASSESSMENT What is the process that large databases use to find patterns and relationships among data?

Accepted Answer

A)  data distribution 
B)  data marketing 
C)  data mining 
D)  data analysis 
A)  data distribution 
B)  data marketing 
C)  data mining 
D)  data analysis

Question 12

COGNITIVE ASSESSMENT You are creating a database for your computer club. Most of the students live in your town, Durham. How can you make Durham appear initially in the field to make data entry easier?

Accepted Answer

A)  make the field a maximum of size characters 
B)  make it the default value 
C)  use AutoComplete 
D)  add a drop-down box 
A)  make the field a maximum of size characters 
B)  make it the default value 
C)  use AutoComplete 
D)  add a drop-down box

Question 13

COGNITIVE ASSESSMENT What is the smallest unit of data the computer can process?

Accepted Answer

A)  log 
B)  bit 
C)  reg 
D)  byte 
A)  log 
B)  bit 
C)  reg 
D)  byte

Question 14

In a relational database, the only data redundancy (duplication) exists in the common columns (fields) used for relationships.

Accepted Answer

A) True 
 B)False

Question 15

The ____________________ identifies users' access privileges, defines the relationships among data, and decides on the proper placement of fields.

Accepted Answer

The answer of The ____________________ identifies users' access privileges, defines...

Question 16

COGNITIVE ASSESSMENT You create a computer-aided design database that stores data including a list of components of an item being designed, the relationship among the components, and previous versions of the design drafts. Which data model did you use?

Accepted Answer

A)  object-oriented 
B)  object-relational 
C)  relational 
D)  multi-dimensional 
A)  object-oriented 
B)  object-relational 
C)  relational 
D)  multi-dimensional

Question 17

Which of the following is a collection of related records, as shown in the accompanying figure, stored on storage media such as a hard drive or optical disc?

Accepted Answer

A)  validator 
B)  rubric 
C)  set 
D)  file 
A)  validator 
B)  rubric 
C)  set 
D)  file

Question 18

Which of the following is a number(s) or character(s) that is appended to or inserted into a primary key field?

Accepted Answer

A)  check digit 
B)  index 
C)  insertion ordinal 
D)  integer 
A)  check digit 
B)  index 
C)  insertion ordinal 
D)  integer

Question 19

COGNITIVE ASSESSMENT What is another name for a database analyst?

Accepted Answer

A)  data query designer 
B)  data modeler 
C)  database administrator 
D)  data master 
A)  data query designer 
B)  data modeler 
C)  database administrator 
D)  data master

Question 20

Which kind of database stores data in dimensions?

Accepted Answer

A)  hypermedia 
B)  hypercube 
C)  multidimensional 
D)  integrated 
A)  hypermedia 
B)  hypercube 
C)  multidimensional 
D)  integrated

In a file processing system, each department or area in an organization shares files collectively.

COGNITIVE ASSESSMENT If you are running a check to ensure that a required field contains data, or the correct minimum number of characters, what kind of check are you running?

Which of the following languages consists of simple, English-like statements that allow users to specify the data to display, print, or store?

In a relational database, users can set up a relationship between tables at any time, but the tables must have a common row or field.

Query by example uses a graphical user interface that assists users with retrieving data.

As shown in the accompanying figure, which of the following is a query language that allows users to manage, update, and retrieve data?

For a computer to produce correct information, the data that is input into a database must have integrity.

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

COGNITIVE ASSESSMENT Which term does a user of a relational database use to refer to a file?

COGNITIVE ASSESSMENT What is the process that large databases use to find patterns and relationships among data?

COGNITIVE ASSESSMENT You are creating a database for your computer club. Most of the students live in your town, Durham. How can you make Durham appear initially in the field to make data entry easier?

COGNITIVE ASSESSMENT What is the smallest unit of data the computer can process?

In a relational database, the only data redundancy (duplication) exists in the common columns (fields) used for relationships.

The ____________________ identifies users' access privileges, defines the relationships among data, and decides on the proper placement of fields.

COGNITIVE ASSESSMENT You create a computer-aided design database that stores data including a list of components of an item being designed, the relationship among the components, and previous versions of the design drafts. Which data model did you use?

Which of the following is a collection of related records, as shown in the accompanying figure, stored on storage media such as a hard drive or optical disc?

Which of the following is a number(s) or character(s) that is appended to or inserted into a primary key field?

COGNITIVE ASSESSMENT What is another name for a database analyst?

Which kind of database stores data in dimensions?

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 a file processing system, each department or area in an organization shares files collectively.

COGNITIVE ASSESSMENT If you are running a check to ensure that a required field contains data, or the correct minimum number of characters, what kind of check are you running?

Which of the following languages consists of simple, English-like statements that allow users to specify the data to display, print, or store?

In a relational database, users can set up a relationship between tables at any time, but the tables must have a common row or field.

Query by example uses a graphical user interface that assists users with retrieving data.

As shown in the accompanying figure, which of the following is a query language that allows users to manage, update, and retrieve data?

For a computer to produce correct information, the data that is input into a database must have integrity.

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

COGNITIVE ASSESSMENT Which term does a user of a relational database use to refer to a file?

COGNITIVE ASSESSMENT What is the process that large databases use to find patterns and relationships among data?

COGNITIVE ASSESSMENT You are creating a database for your computer club. Most of the students live in your town, Durham. How can you make Durham appear initially in the field to make data entry easier?

COGNITIVE ASSESSMENT What is the smallest unit of data the computer can process?

In a relational database, the only data redundancy (duplication) exists in the common columns (fields) used for relationships.

The ____________________ identifies users' access privileges, defines the relationships among data, and decides on the proper placement of fields.

COGNITIVE ASSESSMENT You create a computer-aided design database that stores data including a list of components of an item being designed, the relationship among the components, and previous versions of the design drafts. Which data model did you use?

Which of the following is a collection of related records, as shown in the accompanying figure, stored on storage media such as a hard drive or optical disc?

Which of the following is a number(s) or character(s) that is appended to or inserted into a primary key field?

COGNITIVE ASSESSMENT What is another name for a database analyst?

Which kind of database stores data in dimensions?

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