Question 1

Locks with large granularity are easy for the DBMS to administer but frequently cause conflicts.

Accepted Answer

A) True 
 B)False  True

Question 2

With pessimistic locking,the assumption is made that a conflict will occur.

Accepted Answer

A) True 
 B)False  True

Question 3

Rollforward is a method of database recovery that restores the database save and all valid transactions since the save was reapplied.

Accepted Answer

A) True 
 B)False  True

Question 4

Which type of data repository is composed of metadata that is created automatically as the system components are created?

Accepted Answer

A) Passive 
B) Dynamic 
C) Active 
D) Automatic 
E) Summary 
A) Passive 
B) Dynamic 
C) Active 
D) Automatic 
E) Summary

Question 5

The DBA should periodically analyze run-time statistics of database performance to help manage the DBMS.

Accepted Answer

A) True 
 B)False

Question 6

Recovering a database via rollback involves:

Accepted Answer

A) restoring the database from the save and reprocessing all the transactions since the save. 
B) restoring the database from the save and reapplying all the changes made by transactions since the save. 
C) undoing the changes made by erroneous or partially processed transactions and restarting the valid transactions that were in process at the time of the failure. 
D) re-creating the database by re-entering all of the data from the beginning and,then reprocessing all of the transactions. 
E) synchronizing the database and the transaction log by checkpointing. 
A) restoring the database from the save and reprocessing all the transactions since the save. 
B) restoring the database from the save and reapplying all the changes made by transactions since the save. 
C) undoing the changes made by erroneous or partially processed transactions and restarting the valid transactions that were in process at the time of the failure. 
D) re-creating the database by re-entering all of the data from the beginning and,then reprocessing all of the transactions. 
E) synchronizing the database and the transaction log by checkpointing.

Question 7

The database is most vulnerable to failure after a change to its structure.

Accepted Answer

A) True 
 B)False

Question 8

Briefly define the three problems that can occur because of concurrent processing that are addressed by resource locking.

Accepted Answer

The three problems that can occur becaus

Question 9

Which type of lock still allows other transactions to have read-only access to the locked resource?

Accepted Answer

A) Exclusive lock 
B) Shared lock 
C) Two-phased lock 
D) Explicit lock 
E) Implicit lock 
A) Exclusive lock 
B) Shared lock 
C) Two-phased lock 
D) Explicit lock 
E) Implicit lock

Question 10

Once processing rights have been defined,they may be implemented at any of these levels except:

Accepted Answer

A) network. 
B) operating system. 
C) data. 
D) DBMS. 
E) application. 
A) network. 
B) operating system. 
C) data. 
D) DBMS. 
E) application.

Question 11

Ensuring that all rows impacted by the actions of a transaction are protected from changes until the entire transaction is completed is called:

Accepted Answer

A) statement level consistency. 
B) optimistic locking. 
C) transaction level consistency. 
D) durable transactions. 
E) ARID transactions. 
A) statement level consistency. 
B) optimistic locking. 
C) transaction level consistency. 
D) durable transactions. 
E) ARID transactions.

Question 12

A transaction is sometimes called atomic because it is performed as a unit.

Accepted Answer

A) True 
 B)False

Question 13

The situation that occurs when one user's changes to the database are lost by a second user's changes to the database is known as the:

Accepted Answer

A) lost update problem. 
B) deadly embrace problem. 
C) inconsistent read problem. 
D) inconsistent write problem. 
E) deadlock problem. 
A) lost update problem. 
B) deadly embrace problem. 
C) inconsistent read problem. 
D) inconsistent write problem. 
E) deadlock problem.

Question 14

Recovering a database via rollforward involves:

Accepted Answer

A) restoring the database from the save and reprocessing all the transactions since the save. 
B) restoring the database from the save and reapplying all the changes made by transactions since the save. 
C) undoing the changes made by erroneous or partially processed transactions and restarting the valid transactions that were in process at the time of the failure. 
D) re-creating the database by re-entering all of the data from the beginning,and then reprocessing all of the transactions. 
E) synchronizing the database and the transaction log by checkpointing. 
A) restoring the database from the save and reprocessing all the transactions since the save. 
B) restoring the database from the save and reapplying all the changes made by transactions since the save. 
C) undoing the changes made by erroneous or partially processed transactions and restarting the valid transactions that were in process at the time of the failure. 
D) re-creating the database by re-entering all of the data from the beginning,and then reprocessing all of the transactions. 
E) synchronizing the database and the transaction log by checkpointing.

Question 15

Which of the following is not a database administration responsibility of a DBA?

Accepted Answer

A) Managing the database structure 
B) Managing data activity 
C) Managing the DBMS 
D) Maintaining the data repository 
E) All of the above are database administration responsibilities of a DBA. 
A) Managing the database structure 
B) Managing data activity 
C) Managing the DBMS 
D) Maintaining the data repository 
E) All of the above are database administration responsibilities of a DBA.

Question 16

Copies of each database record or page after it was changed by a transaction that are saved for use in database recovery are called ghost images.

Accepted Answer

A) True 
 B)False

Question 17

Locks placed by a command issued to the DBMS from the application program are called explicit locks.

Accepted Answer

A) True 
 B)False

Question 18

A series of actions to be taken on the database such that either all actions are completed successfully,or none of them can be completed,is known as a:

Accepted Answer

A) checkpoint. 
B) log. 
C) lock. 
D) transaction. 
E) concurrent. 
A) checkpoint. 
B) log. 
C) lock. 
D) transaction. 
E) concurrent.

Question 19

Nonrepeatable reads occur when a transaction rereads data it has previously read and finds modifications or deletions caused by a committed transaction.

Accepted Answer

A) True 
 B)False

Question 20

Which of the following is true of forward only cursors?

Accepted Answer

A) Current values for each row are retrieved when the application accesses a row. 
B) All changes of any type from any source are visible. 
C) Changes made by the transaction are visible only if they occur on rows ahead of the cursor. 
D) Applications may scroll backward in the record set. 
E) It requires the greatest overhead of any cursor type. 
A) Current values for each row are retrieved when the application accesses a row. 
B) All changes of any type from any source are visible. 
C) Changes made by the transaction are visible only if they occur on rows ahead of the cursor. 
D) Applications may scroll backward in the record set. 
E) It requires the greatest overhead of any cursor type.

Exam 9: Managing Multiuser Databases

Locks with large granularity are easy for the DBMS to administer but frequently cause conflicts.

With pessimistic locking,the assumption is made that a conflict will occur.

Rollforward is a method of database recovery that restores the database save and all valid transactions since the save was reapplied.

Which type of data repository is composed of metadata that is created automatically as the system components are created?

The DBA should periodically analyze run-time statistics of database performance to help manage the DBMS.

Recovering a database via rollback involves:

The database is most vulnerable to failure after a change to its structure.

Briefly define the three problems that can occur because of concurrent processing that are addressed by resource locking.

Which type of lock still allows other transactions to have read-only access to the locked resource?

Once processing rights have been defined,they may be implemented at any of these levels except:

Ensuring that all rows impacted by the actions of a transaction are protected from changes until the entire transaction is completed is called:

A transaction is sometimes called atomic because it is performed as a unit.

The situation that occurs when one user's changes to the database are lost by a second user's changes to the database is known as the:

Recovering a database via rollforward involves:

Which of the following is not a database administration responsibility of a DBA?

Copies of each database record or page after it was changed by a transaction that are saved for use in database recovery are called ghost images.

Locks placed by a command issued to the DBMS from the application program are called explicit locks.

A series of actions to be taken on the database such that either all actions are completed successfully,or none of them can be completed,is known as a:

Nonrepeatable reads occur when a transaction rereads data it has previously read and finds modifications or deletions caused by a committed transaction.

Which of the following is true of forward only cursors?

Introduction

Introduction to Structured Query Language SQL

The Relational Model and Normalization

Database Design Using Normalization

Data Modeling With the Entity-Relationship Model

Transforming Data Models Into Database Designs

SQL for Database Construction and Application Processing

Database Redesign

Managing Databases With SQL Server 2008 R2

Managing Databases With Oracle Database 11g

Managing Databases With MySQL 55

The Web Server Environment

Database Processing With XML

Database Processing for Business Intelligence Systems

Microsoft Access 2010

Getting Started With Systems Analysis and Design

E-R Diagrams and the Idef1x Standard

E-R Diagrams and the UML Standard

Getting Started With MySQL Workbench Data Modeling Tools

Getting Started With Microsoft Visio 2010

the Semantic Object Model

Data Structures for Database Processing

Getting Started With Web Servers php and the Eclipse PDT

Filters