Question 1

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  True

Question 2

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

Accepted Answer

A) True 
 B)False  True

Question 3

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 B

Question 4

Processing responsibilities should be documented and encoded into manual procedures.

Accepted Answer

A) True 
 B)False

Question 5

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 6

Processing rights may be implemented at the DBMS level.

Accepted Answer

A) True 
 B)False

Question 7

Explain the concept of an "atomic transaction."

Accepted Answer

An atomic transaction is a transaction i

Question 8

The situation that occurs when two users are each waiting for a resource that the other person has locked is known as a(n):

Accepted Answer

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

Question 9

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

Question 10

One important reason for documenting changes to the database structure is for diagnosing errors.

Accepted Answer

A) True 
 B)False

Question 11

The task of diagnosing errors due to changes in the database structure is eased by:

Accepted Answer

A) formal policies for requesting changes. 
B) database structure change documentation. 
C) rollback analysis. 
D) configuration control. 
E) None of the above. 
A) formal policies for requesting changes. 
B) database structure change documentation. 
C) rollback analysis. 
D) configuration control. 
E) None of the above.

Question 12

A lock placed automatically by the DBMS is called a(n)________ lock.

Accepted Answer

A) exclusive 
B) explicit 
C) granular 
D) implicit 
E) shared 
A) exclusive 
B) explicit 
C) granular 
D) implicit 
E) shared

Question 13

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.

Question 14

Which of the following would not be contained in a transaction log?

Accepted Answer

A) Before images 
B) Type of operation 
C) Pointers 
D) Time of the action 
E) Permissions 
A) Before images 
B) Type of operation 
C) Pointers 
D) Time of the action 
E) Permissions

Question 15

A transaction is a group of alternative database actions,from which the database can choose to perform only one of them.

Accepted Answer

A) True 
 B)False

Question 16

Which of the following cannot be enforced in the DBMS or application programs?

Accepted Answer

A) processing rights 
B) security 
C) processing responsibilities 
D) cursors 
E) transaction isolation 
A) processing rights 
B) security 
C) processing responsibilities 
D) cursors 
E) transaction isolation

Question 17

When a transaction rereads data that has been changed and finds changes due to committed transactions,this is known as a ________.

Accepted Answer

A) Clean read 
B) Dirty read 
C) Nonrepeatable read 
D) Phantom read 
A) Clean read 
B) Dirty read 
C) Nonrepeatable read 
D) Phantom read

Question 18

Which of the following is not true of data repositories?

Accepted Answer

A) They are usually created after the database has been implemented and optimized for performance. 
B) They may be virtual. 
C) They may contain metadata about database applications. 
D) They may contain metadata about users. 
E) They may contain metadata about Web pages. 
A) They are usually created after the database has been implemented and optimized for performance. 
B) They may be virtual. 
C) They may contain metadata about database applications. 
D) They may contain metadata about users. 
E) They may contain metadata about Web pages.

Question 19

Reprocessing is normally the most convenient method for recovery after a system failure.

Accepted Answer

A) True 
 B)False

Question 20

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.

Exam 9: Managing Multiuser Databases

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

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

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

Processing responsibilities should be documented and encoded into manual procedures.

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

Processing rights may be implemented at the DBMS level.

Explain the concept of an "atomic transaction."

The situation that occurs when two users are each waiting for a resource that the other person has locked is known as a(n):

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

One important reason for documenting changes to the database structure is for diagnosing errors.

The task of diagnosing errors due to changes in the database structure is eased by:

A lock placed automatically by the DBMS is called a(n)________ lock.

Which of the following is true of forward only cursors?

Which of the following would not be contained in a transaction log?

A transaction is a group of alternative database actions,from which the database can choose to perform only one of them.

Which of the following cannot be enforced in the DBMS or application programs?

When a transaction rereads data that has been changed and finds changes due to committed transactions,this is known as a ________.

Which of the following is not true of data repositories?

Reprocessing is normally the most convenient method for recovery after a system failure.

Recovering a database via rollforward involves:

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

A: Managing Databases With SQL Server 20012

B: Managing Databases With Oracle Database 11g Release 2

C: Managing Databases With MySQL

The Web Server Environment

Big Data datawarehouse and Business Intelligence Systems

Microsoft Access 2013

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 2013

Data Structures for Database Processing

the Semantic Object Model

Getting Started With Web Servers php and the Eclipse PDT

Business Intelligence Systems

Filters