Question 1

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

Accepted Answer

A) They store data in tables. 
B) They store relationships. 
C) They use two-dimensional tables. 
D) They store data in objects. 
A) They store data in tables. 
B) They store relationships. 
C) They use two-dimensional tables. 
D) They store data in objects. D

Question 2

Identify the letter of the choice that best matches the phrase or definition.
-A field that uniquely identifies each record in a file.

Accepted Answer

A) proof of concept 
B) unit test 
C) systems test 
D) integration test 
E) acceptance test
F)useful
G)documentation
H)character
I)record
J)primary key
K)SQL
L)flagged
M)inaccurate
N)byte
O)DBMS
P)validation
Q)data relationships
R)querying
S)functions
T)integrity 
A) proof of concept 
B) unit test 
C) systems test 
D) integration test 
E) acceptance test
F)useful
G)documentation
H)character
I)record
J)primary key
K)SQL
L)flagged
M)inaccurate
N)byte
O)DBMS
P)validation
Q)data relationships
R)querying
S)functions
T)integrity J

Question 3

A relational database stores data in objects.

Accepted Answer

A) True 
 B)False  False

Question 4

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 5

Identify the letter of the choice that best matches the phrase or definition.
-What is done to a record so the DBMS will not process it again.

Accepted Answer

A) proof of concept 
B) unit test 
C) systems test 
D) integration test 
E) acceptance test
F)useful
G)documentation
H)character
I)record
J)primary key
K)SQL
L)flagged
M)inaccurate
N)byte
O)DBMS
P)validation
Q)data relationships
R)querying
S)functions
T)integrity 
A) proof of concept 
B) unit test 
C) systems test 
D) integration test 
E) acceptance test
F)useful
G)documentation
H)character
I)record
J)primary key
K)SQL
L)flagged
M)inaccurate
N)byte
O)DBMS
P)validation
Q)data relationships
R)querying
S)functions
T)integrity

Question 6

Which of the following is a nonprocedural language that enables users and software developers to access data in a database?

Accepted Answer

A) 4SL 
B) 4DB 
C) 4GL 
D) 4AE 
A) 4SL 
B) 4DB 
C) 4GL 
D) 4AE

Question 7

____________________ is a common data type that consists of an email address or a web address that links to a webpage on the Internet, for example.

Accepted Answer

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

Question 8

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 9

Which of the following is a collection of data organized in a manner that allows access, retrieval, and use of that data?

Accepted Answer

A) database 
B) server 
C) spreadsheet 
D) webbase 
A) database 
B) server 
C) spreadsheet 
D) webbase

Question 10

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 11

More than 30 years ago, the first macro viruses wreaked havoc with personal computers.

Accepted Answer

A) True 
 B)False

Question 12

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.
-The instructor tells you that this is a mailing database, and yet you can see at a glance that there are some records with no data in the city field. What kind of check should you run on this field?

Accepted Answer

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

Question 13

SQL stands for which of the following?

Accepted Answer

A) Structured Query Language 
B) Statement Query Language 
C) Standard Query Language 
D) Student Query Language 
A) Structured Query Language 
B) Statement Query Language 
C) Standard Query Language 
D) Student Query Language

Question 14

____________________ is a common data type that consists of lengthy text entries.

Accepted Answer

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

Question 15

Which of the following is a program with which users interact that generally has a more user-friendly interface than a DBMS?

Accepted Answer

A) back end 
B) RDBMS 
C) SQL 
D) front end 
A) back end 
B) RDBMS 
C) SQL 
D) front end

Question 16

Identify the letter of the choice that best matches the phrase or definition.
-This database capability is one of the more powerful database features.

Accepted Answer

A) proof of concept 
B) unit test 
C) systems test 
D) integration test 
E) acceptance test
F)useful
G)documentation
H)character
I)record
J)primary key
K)SQL
L)flagged
M)inaccurate
N)byte
O)DBMS
P)validation
Q)data relationships
R)querying
S)functions
T)integrity 
A) proof of concept 
B) unit test 
C) systems test 
D) integration test 
E) acceptance test
F)useful
G)documentation
H)character
I)record
J)primary key
K)SQL
L)flagged
M)inaccurate
N)byte
O)DBMS
P)validation
Q)data relationships
R)querying
S)functions
T)integrity

Question 17

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

Accepted Answer

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

Question 18

What type of database are organizations MOST LIKELY to use for payroll, accounts receivable, inventory, and invoicing?

Accepted Answer

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

Question 19

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 20

Key fields link data together in a database.

Accepted Answer

A) True 
 B)False

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

Identify the letter of the choice that best matches the phrase or definition. -A field that uniquely identifies each record in a file.

A relational database stores data in objects.

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

Identify the letter of the choice that best matches the phrase or definition. -What is done to a record so the DBMS will not process it again.

Which of the following is a nonprocedural language that enables users and software developers to access data in a database?

____________________ is a common data type that consists of an email address or a web address that links to a webpage on the Internet, for example.

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

Which of the following is a collection of data organized in a manner that allows access, retrieval, and use of that data?

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

More than 30 years ago, the first macro viruses wreaked havoc with personal computers.

SQL stands for which of the following?

____________________ is a common data type that consists of lengthy text entries.

Which of the following is a program with which users interact that generally has a more user-friendly interface than a DBMS?

Identify the letter of the choice that best matches the phrase or definition. -This database capability is one of the more powerful database features.

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

What type of database are organizations MOST LIKELY to use for payroll, accounts receivable, inventory, and invoicing?

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

Key fields link data together in a database.

Introducing Todays Technologies

Connecting and Communicating Online

Computers and Mobile Devices

Programs and Apps

Digital Security, Ethics, and Privacy

Computing Components

Input and Output

Digital Storage

Operating Systems

Communicating Digital Content

Working in the Enterprise

Filters

Exam 11: Building Solutions

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

Identify the letter of the choice that best matches the phrase or definition. -A field that uniquely identifies each record in a file.

A relational database stores data in objects.

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

Identify the letter of the choice that best matches the phrase or definition. -What is done to a record so the DBMS will not process it again.

Which of the following is a nonprocedural language that enables users and software developers to access data in a database?

____________________ is a common data type that consists of an email address or a web address that links to a webpage on the Internet, for example.

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

Which of the following is a collection of data organized in a manner that allows access, retrieval, and use of that data?

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

More than 30 years ago, the first macro viruses wreaked havoc with personal computers.

SQL stands for which of the following?

____________________ is a common data type that consists of lengthy text entries.

Which of the following is a program with which users interact that generally has a more user-friendly interface than a DBMS?

Identify the letter of the choice that best matches the phrase or definition. -This database capability is one of the more powerful database features.

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

What type of database are organizations MOST LIKELY to use for payroll, accounts receivable, inventory, and invoicing?

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

Key fields link data together in a database.

Introducing Todays Technologies

Connecting and Communicating Online

Computers and Mobile Devices

Programs and Apps

Digital Security, Ethics, and Privacy

Computing Components

Input and Output

Digital Storage

Operating Systems

Communicating Digital Content

Working in the Enterprise

Filters