Question 1

The goal of database security is the protection of data from accidental or intentional threats to its integrity and access.

Accepted Answer

A) True 
 B)False

Question 2

Which of the following functions are supported by a repository engine?

Accepted Answer

A)  Object management 
B)  Relationship management 
C)  Version management 
D)  All of the above 
A)  Object management 
B)  Relationship management 
C)  Version management 
D)  All of the above

Question 3

Database applications are not very disk intensive.

Accepted Answer

A) True 
 B)False

Question 4

A trigger can be used as a security measure in which of the following ways?

Accepted Answer

A)  To prohibit inappropriate actions 
B)  To cause special handling procedures to be executed 
C)  To cause a row to be written to a log file 
D)  All of the above 
A)  To prohibit inappropriate actions 
B)  To cause special handling procedures to be executed 
C)  To cause a row to be written to a log file 
D)  All of the above

Question 5

What are the most important security features for data management software?

Accepted Answer

The most important security features of

Question 6

When incorrect data have been introduced,the database is best recovered by:

Accepted Answer

A)  backward recovery, if the error has been discovered soon enough. 
B)  human intervention for only a few errors. 
C)  restarting from the most recent checkpoint and processing subsequent transactions. 
D)  all of the above. 
A)  backward recovery, if the error has been discovered soon enough. 
B)  human intervention for only a few errors. 
C)  restarting from the most recent checkpoint and processing subsequent transactions. 
D)  all of the above.

Question 7

What threats to data security must be addressed in a comprehensive data security plan?

Accepted Answer

A comprehensive data security plan must

Question 8

The first line of defense for authentication is the use of passwords,which is a one-factor authentication scheme.

Accepted Answer

A) True 
 B)False

Question 9

A(n)________ is a component that stores metadata.

Accepted Answer

informatio

Question 10

A repository of information about data is called a catalog.

Accepted Answer

A) True 
 B)False

Question 11

The coding or scrambling of data so that humans cannot read them is called ________.

Accepted Answer

The answer of The coding or scrambling of data so...

Question 12

The actions that must be taken to ensure data integrity is maintained during multiple simultaneous transactions are called ________ actions.

Accepted Answer

A)  logging 
B)  concurrency control 
C)  transaction authorization 
D)  multiple management 
A)  logging 
B)  concurrency control 
C)  transaction authorization 
D)  multiple management

Question 13

A shared lock allows other transactions to read but not update records in use.

Accepted Answer

A) True 
 B)False

Question 14

The W3C standard for Web privacy is called:

Accepted Answer

A)  The Web privacy act. 
B)  Platform for Privacy Preferences. 
C)  Freedom of Web Information Act. 
D)  The Magna Carta. 
A)  The Web privacy act. 
B)  Platform for Privacy Preferences. 
C)  Freedom of Web Information Act. 
D)  The Magna Carta.

Question 15

Concurrent transactions need to be processed in isolation so that they do not interfere with each other.

Accepted Answer

A) True 
 B)False

Question 16

The granularity of locking is not a critical decision in database design.

Accepted Answer

A) True 
 B)False

Question 17

________ is used to undo unwanted database changes.

Accepted Answer

A)  Rollback 
B)  Rollforward 
C)  Restart 
D)  Encryption 
A)  Rollback 
B)  Rollforward 
C)  Restart 
D)  Encryption

Question 18

Loss of data integrity does not impact the quality of data in a database.

Accepted Answer

A) True 
 B)False

Question 19

Any data that are retrieved by a user for updating must be ________ until the update is completed or aborted.

Accepted Answer

The answer of Any data that are retrieved by a...

Question 20

What are the four basic facilities that a database management system should provide for backup and recovery?

Accepted Answer

The four basic facilities are:
1.backup

The goal of database security is the protection of data from accidental or intentional threats to its integrity and access.

Which of the following functions are supported by a repository engine?

Database applications are not very disk intensive.

A trigger can be used as a security measure in which of the following ways?

What are the most important security features for data management software?

When incorrect data have been introduced,the database is best recovered by:

What threats to data security must be addressed in a comprehensive data security plan?

The first line of defense for authentication is the use of passwords,which is a one-factor authentication scheme.

A(n)________ is a component that stores metadata.

A repository of information about data is called a catalog.

The coding or scrambling of data so that humans cannot read them is called ________.

The actions that must be taken to ensure data integrity is maintained during multiple simultaneous transactions are called ________ actions.

A shared lock allows other transactions to read but not update records in use.

The W3C standard for Web privacy is called:

Concurrent transactions need to be processed in isolation so that they do not interfere with each other.

The granularity of locking is not a critical decision in database design.

________ is used to undo unwanted database changes.

Loss of data integrity does not impact the quality of data in a database.

Any data that are retrieved by a user for updating must be ________ until the update is completed or aborted.

What are the four basic facilities that a database management system should provide for backup and recovery?

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model and Business Rules

Logical Database Design and the Relational Model

Physical Database Design and Performance

Introduction to SQL

Advanced SQL

Database Application Development

Data Warehousing

Data Quality and Integration

Distributed Databases

Object-Oriented Data Modeling

Using Relational Databases to Provide Object Persistence

Filters

Exam 11: Data and Database Administration

The goal of database security is the protection of data from accidental or intentional threats to its integrity and access.

Which of the following functions are supported by a repository engine?

Database applications are not very disk intensive.

A trigger can be used as a security measure in which of the following ways?

What are the most important security features for data management software?

When incorrect data have been introduced,the database is best recovered by:

What threats to data security must be addressed in a comprehensive data security plan?

The first line of defense for authentication is the use of passwords,which is a one-factor authentication scheme.

A(n)________ is a component that stores metadata.

A repository of information about data is called a catalog.

The coding or scrambling of data so that humans cannot read them is called ________.

The actions that must be taken to ensure data integrity is maintained during multiple simultaneous transactions are called ________ actions.

A shared lock allows other transactions to read but not update records in use.

The W3C standard for Web privacy is called:

Concurrent transactions need to be processed in isolation so that they do not interfere with each other.

The granularity of locking is not a critical decision in database design.

________ is used to undo unwanted database changes.

Loss of data integrity does not impact the quality of data in a database.

Any data that are retrieved by a user for updating must be ________ until the update is completed or aborted.

What are the four basic facilities that a database management system should provide for backup and recovery?

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model and Business Rules

Logical Database Design and the Relational Model

Physical Database Design and Performance

Introduction to SQL

Advanced SQL

Database Application Development

Data Warehousing

Data Quality and Integration

Distributed Databases

Object-Oriented Data Modeling

Using Relational Databases to Provide Object Persistence

Filters