Question 1

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 2

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

Accepted Answer

A) True 
 B)False

Question 3

What does the S in SQL stand for?

Accepted Answer

A) Server 
B) System 
C) Structured 
D) Serial 
A) Server 
B) System 
C) Structured 
D) Serial

Question 4

What is the process of comparing data with a set of rules or values to determine if the data meets certain criteria?

Accepted Answer

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

Question 5

Which of the following refers to the procedures that keep data current?

Accepted Answer

A) file maintenance 
B) authentication integrity 
C) data validation 
D) information checking 
A) file maintenance 
B) authentication integrity 
C) data validation 
D) information checking

Question 6

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

Accepted Answer

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

Question 7

Identify the letter of the choice that best matches the phrase or definition.
-Has special keywords and rules that users include in statements.

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 8

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 9

Some report generators allow you to create a webpage, which can be interactive.

Accepted Answer

A) True 
 B)False

Question 10

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

Question 11

A(n) ____________________ verifies that a required field contains data.

Accepted Answer

The answer of A(n) ____________________ verifies that a required field...

Question 12

A web database usually resides on a database server.

Accepted Answer

A) True 
 B)False

Question 13

Which of the following privileges for data involve establishing who can enter new data, change existing data, delete unwanted data, and view data?

Accepted Answer

A) viewing 
B) writing 
C) reading 
D) access 
A) viewing 
B) writing 
C) reading 
D) access

Question 14

-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 15

Which of the following kind of checks is a validity check performed on data, which ensures users enter only numeric data into a field?

Accepted Answer

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

Question 16

Each higher level of data consists of one or more items from the lower level.

Accepted Answer

A) True 
 B)False

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 on cloud storage?

Accepted Answer

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

Question 18

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 19

With a(n) ____________________, users create a computerized database; add, modify, and delete data in the database; sort and retrieve data from the database; and create forms and reports from the data in the database.

Accepted Answer

database management

Question 20

A table that has rows and columns is what type of table?

Accepted Answer

A) three-dimensional 
B) primary 
C) two-dimensional 
D) object-oriented 
A) three-dimensional 
B) primary 
C) two-dimensional 
D) object-oriented

What is another term for data dictionary?

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

What does the S in SQL stand for?

What is the process of comparing data with a set of rules or values to determine if the data meets certain criteria?

Which of the following refers to the procedures that keep data current?

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

Identify the letter of the choice that best matches the phrase or definition. -Has special keywords and rules that users include in statements.

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

Some report generators allow you to create a webpage, which can be interactive.

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

A(n) ____________________ verifies that a required field contains data.

A web database usually resides on a database server.

Which of the following privileges for data involve establishing who can enter new data, change existing data, delete unwanted data, and view data?

-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?

Which of the following kind of checks is a validity check performed on data, which ensures users enter only numeric data into a field?

Each higher level of data consists of one or more items from the lower level.

-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 on cloud storage?

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

With a(n) ____________________, users create a computerized database; add, modify, and delete data in the database; sort and retrieve data from the database; and create forms and reports from the data in the database.

A table that has rows and columns is what type of table?

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

What is another term for data dictionary?

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

What does the S in SQL stand for?

What is the process of comparing data with a set of rules or values to determine if the data meets certain criteria?

Which of the following refers to the procedures that keep data current?

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

Identify the letter of the choice that best matches the phrase or definition. -Has special keywords and rules that users include in statements.

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

Some report generators allow you to create a webpage, which can be interactive.

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

A(n) ____________________ verifies that a required field contains data.

A web database usually resides on a database server.

Which of the following privileges for data involve establishing who can enter new data, change existing data, delete unwanted data, and view data?

-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?

Which of the following kind of checks is a validity check performed on data, which ensures users enter only numeric data into a field?

Each higher level of data consists of one or more items from the lower level.

-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 on cloud storage?

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

With a(n) ____________________, users create a computerized database; add, modify, and delete data in the database; sort and retrieve data from the database; and create forms and reports from the data in the database.

A table that has rows and columns is what type of table?

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