Question 1

Match between columns
                        Premises: Whether designed for a small or large computer, most DBMSs perform common ones.
A field that uniquely identifies each record in a file.
What is done to a record so the DBMS will not process it again.
Information that is error free.
Information that has meaning to the person who receives it.
In addition to storing data, a relational database also stores these.
What each byte represents in ASCII.
Phrase that points out the accuracy of a computer's output depends on the accuracy of the input.
The more errors the data contains, the lower this is.
Information that is arranged to suit the needs and requirements of the decision maker.
This type of information can lead to incorrect decisions.
Information that should give more value than it costs to produce.
Information that has an age suited to its use.
Eight bits grouped together in a unit comprise this.
Information that can be proven as correct or incorrect.
Kind of rules that decrease data entry errors, and thus enhance the data's integrity.
Has special keywords and rules that users include in SQL statements.
This database capability is one of the more powerful database features.
A group of related fields.
While a user is working with the database, this resides in the memory of the computer.

Accepted Answer

The Answer of flagged and inaccurate and functions and timely is...

Question 2

A web database usually resides on a(n) ____________________.

Accepted Answer

The answer of A web database usually resides on a(n)...

Question 3

Which of the following kinds of backup are used by organizations such as hospitals, communications companies, and financial institutions?

Accepted Answer

A)  dynamic 
B)  interactive 
C)  collaborative 
D)  continuous 
A)  dynamic 
B)  interactive 
C)  collaborative 
D)  continuous

Question 4

Most DBMSs include a feature, as shown in the middle image within the accompanying figure, which has a graphical user interface to assist users with retrieving data. What is this feature called?

Accepted Answer

A)  QBA 
B)  SQL 
C)  QBE 
D)  schema 
A)  QBA 
B)  SQL 
C)  QBE 
D)  schema

Question 5

____________________ helps salespeople manage customer contacts, schedule customer meetings, log customer interactions, manage product information, and place customer orders.

Accepted Answer

Salesforce

Question 6

COGNITIVE ASSESSMENT While working with a database, you encounter a wizard. What best describes the purpose of a wizard?

Accepted Answer

A)  guides you through the steps of creating a database object 
B)  the database creator and administrator 
C)  a screen in which you enter or modify data 
D)  the instructions that control how the data in the database is connected 
A)  guides you through the steps of creating a database object 
B)  the database creator and administrator 
C)  a screen in which you enter or modify data 
D)  the instructions that control how the data in the database is connected

Question 7

COGNITIVE ASSESSMENT Which of the following is not one of the qualities associated with identifying the value of information?

Accepted Answer

A)  accurate 
B)  verifiable 
C)  useful 
D)  expensive 
A)  accurate 
B)  verifiable 
C)  useful 
D)  expensive

Question 8

____________________ is a common data type that includes letters, numbers, or special characters.

Accepted Answer

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

Question 9

Critical Thinking Questions Case 11-1
In your new role as a DBA, you have inherited a database that has a lot of problems. Your first task, you decide, is to identify whether or not the information in your database contains the qualities of valuable information, and which quality may be missing.
The manager for the eastern division sales force is upset because she wants to determine which members of her sales force need awards for high monthly sales, and which employees need remediation because they have not sold enough product during the past month. However, all of the sales information has not yet been entered into the database. What kind of information is at issue in this instance?

Accepted Answer

A)  useful information 
B)  timely information 
C)  accessible information 
D)  verifiable information 
A)  useful information 
B)  timely information 
C)  accessible information 
D)  verifiable information

Question 10

To assist with sound decision making, the information must have value.

Accepted Answer

A) True 
 B)False

Question 11

Timely information has an age suited to its use.

Accepted Answer

A) True 
 B)False

Question 12

COGNITIVE ASSESSMENT Which term does the developer of a relational database use to describe a record?

Accepted Answer

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

Question 13

COGNITIVE ASSESSMENT What company did Larry Ellison help found?

Accepted Answer

A)  Oracle 
B)  Sun Microsystems 
C)  Sybase 
D)  Microsoft 
A)  Oracle 
B)  Sun Microsystems 
C)  Sybase 
D)  Microsoft

Question 14

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

Accepted Answer

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

Question 15

Compared with relational databases, which of the following is NOT true of object-oriented databases?

Accepted Answer

A)  They can store more types of data. 
B)  They access data faster. 
C)  They allow programmers to reuse objects. 
D)  They store unstructured information less efficiently. 
A)  They can store more types of data. 
B)  They access data faster. 
C)  They allow programmers to reuse objects. 
D)  They store unstructured information less efficiently.

Question 16

COGNITIVE ASSESSMENT What is another term for data dictionary?

Accepted Answer

A)  index 
B)  repository 
C)  file 
D)  table 
A)  index 
B)  repository 
C)  file 
D)  table

Question 17

COGNITIVE ASSESSMENT Which of the following statements is not true about report writers?

Accepted Answer

A)  You use a report writer only to retrieve data. 
B)  Report writers usually allow you to format page numbers and dates; titles and column headings; subtotals and totals; and fonts, font sizes, color, and shading. 
C)  The capability of creating reports is rare in a DBMS. 
D)  Some report writers allow you to include images. 
A)  You use a report writer only to retrieve data. 
B)  Report writers usually allow you to format page numbers and dates; titles and column headings; subtotals and totals; and fonts, font sizes, color, and shading. 
C)  The capability of creating reports is rare in a DBMS. 
D)  Some report writers allow you to include images.

Question 18

____________________ information is available when a decision maker needs it.

Accepted Answer

The answer of ____________________ information is available when a decision...

Question 19

Which of the following, with regard to the entire database, should be made on a regular basis?

Accepted Answer

A)  backup 
B)  baseline 
C)  after image 
D)  retread 
A)  backup 
B)  baseline 
C)  after image 
D)  retread

Question 20

COGNITIVE ASSESSMENT Which recovery technique is more expensive, but provides recovery of damaged data in a matter of seconds?

Accepted Answer

A)  rollforward 
B)  rollbackward 
C)  continuous backup 
D)  instant restoration 
A)  rollforward 
B)  rollbackward 
C)  continuous backup 
D)  instant restoration

A web database usually resides on a(n) ____________________.

Which of the following kinds of backup are used by organizations such as hospitals, communications companies, and financial institutions?

Most DBMSs include a feature, as shown in the middle image within the accompanying figure, which has a graphical user interface to assist users with retrieving data. What is this feature called?

____________________ helps salespeople manage customer contacts, schedule customer meetings, log customer interactions, manage product information, and place customer orders.

COGNITIVE ASSESSMENT While working with a database, you encounter a wizard. What best describes the purpose of a wizard?

COGNITIVE ASSESSMENT Which of the following is not one of the qualities associated with identifying the value of information?

____________________ is a common data type that includes letters, numbers, or special characters.

To assist with sound decision making, the information must have value.

Timely information has an age suited to its use.

COGNITIVE ASSESSMENT Which term does the developer of a relational database use to describe a record?

COGNITIVE ASSESSMENT What company did Larry Ellison help found?

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

Compared with relational databases, which of the following is NOT true of object-oriented databases?

COGNITIVE ASSESSMENT What is another term for data dictionary?

COGNITIVE ASSESSMENT Which of the following statements is not true about report writers?

____________________ information is available when a decision maker needs it.

Which of the following, with regard to the entire database, should be made on a regular basis?

COGNITIVE ASSESSMENT Which recovery technique is more expensive, but provides recovery of damaged data in a matter of seconds?

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 web database usually resides on a(n) ____________________.

Which of the following kinds of backup are used by organizations such as hospitals, communications companies, and financial institutions?

Most DBMSs include a feature, as shown in the middle image within the accompanying figure, which has a graphical user interface to assist users with retrieving data. What is this feature called?

____________________ helps salespeople manage customer contacts, schedule customer meetings, log customer interactions, manage product information, and place customer orders.

COGNITIVE ASSESSMENT While working with a database, you encounter a wizard. What best describes the purpose of a wizard?

COGNITIVE ASSESSMENT Which of the following is not one of the qualities associated with identifying the value of information?

____________________ is a common data type that includes letters, numbers, or special characters.

To assist with sound decision making, the information must have value.

Timely information has an age suited to its use.

COGNITIVE ASSESSMENT Which term does the developer of a relational database use to describe a record?

COGNITIVE ASSESSMENT What company did Larry Ellison help found?

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

Compared with relational databases, which of the following is NOT true of object-oriented databases?

COGNITIVE ASSESSMENT What is another term for data dictionary?

COGNITIVE ASSESSMENT Which of the following statements is not true about report writers?

____________________ information is available when a decision maker needs it.

Which of the following, with regard to the entire database, should be made on a regular basis?

COGNITIVE ASSESSMENT Which recovery technique is more expensive, but provides recovery of damaged data in a matter of seconds?

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