Question 1

What is a journalizing facility?

Accepted Answer

A journalizing facility provides an audi

Question 2

A credit-card sized plastic card with an embedded microprocessor chip with the ability to store, process and output electronic data in a secure manner is called a(n):

Accepted Answer

A)  smart chip. 
B)  smart card. 
C)  e-credit card. 
D)  secure card. 
A)  smart chip. 
B)  smart card. 
C)  e-credit card. 
D)  secure card.

Question 3

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

Accepted Answer

A)  starting with a new ERD. 
B)  formatting server. 
C)  restarting from the most recent checkpoint and processing subsequent transactions. 
D)  reloading RDMS software. 
A)  starting with a new ERD. 
B)  formatting server. 
C)  restarting from the most recent checkpoint and processing subsequent transactions. 
D)  reloading RDMS software.

Question 4

A deadlock results when two transactions try to read the same record.

Accepted Answer

A) True 
 B)False

Question 5

Which of the following is NOT an area of concern when trying to maintain a well-tuned database?

Accepted Answer

A)  Memory usage 
B)  CPU usage 
C)  Input/output contention 
D)  User interface design 
A)  Memory usage 
B)  CPU usage 
C)  Input/output contention 
D)  User interface design

Question 6

Authorization rules are controls incorporated in the data management system that restrict access to data and also restrict the actions that people may take when they access the data.

Accepted Answer

A) True 
 B)False

Question 7

The ________ occurs when one user reads data that have been partially updated by another user.

Accepted Answer

A)  inconsistent read problem 
B)  distant read problem 
C)  honest dirty data 
D)  data quality problem 
A)  inconsistent read problem 
B)  distant read problem 
C)  honest dirty data 
D)  data quality problem

Question 8

Versioning takes the pessimistic approach to locking.

Accepted Answer

A) True 
 B)False

Question 9

Which of the following functions develop integrity controls?

Accepted Answer

A)  Database planning 
B)  Database analysis 
C)  Database implementation 
D)  Database design 
A)  Database planning 
B)  Database analysis 
C)  Database implementation 
D)  Database design

Question 10

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

Accepted Answer

A)  To check for viruses 
B)  To cause special handling procedures to be executed 
C)  To design a database 
D)  To conduct a DFD analysis 
A)  To check for viruses 
B)  To cause special handling procedures to be executed 
C)  To design a database 
D)  To conduct a DFD analysis

What is a journalizing facility?

A credit-card sized plastic card with an embedded microprocessor chip with the ability to store, process and output electronic data in a secure manner is called a(n):

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

A deadlock results when two transactions try to read the same record.

Which of the following is NOT an area of concern when trying to maintain a well-tuned database?

Authorization rules are controls incorporated in the data management system that restrict access to data and also restrict the actions that people may take when they access the data.

The ________ occurs when one user reads data that have been partially updated by another user.

Versioning takes the pessimistic approach to locking.

Which of the following functions develop integrity controls?

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

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model

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

Big Data and Analytics

Distributed Databases

Object-Oriented Data Modeling

Filters

Exam 12: Data and Database Administration

What is a journalizing facility?

A credit-card sized plastic card with an embedded microprocessor chip with the ability to store, process and output electronic data in a secure manner is called a(n):

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

A deadlock results when two transactions try to read the same record.

Which of the following is NOT an area of concern when trying to maintain a well-tuned database?

Authorization rules are controls incorporated in the data management system that restrict access to data and also restrict the actions that people may take when they access the data.

The ________ occurs when one user reads data that have been partially updated by another user.

Versioning takes the pessimistic approach to locking.

Which of the following functions develop integrity controls?

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

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model

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

Big Data and Analytics

Distributed Databases

Object-Oriented Data Modeling

Filters