Question 1

The transaction boundaries are the essential information that the DBMS needs from the application programs to enforce different locking strategies.

Accepted Answer

A) True 
 B)False

Question 2

Rollforward and reprocessing are two different names for the same technique.

Accepted Answer

A) True 
 B)False

Question 3

In general,optimistic locking is the preferred technique for Internet databases.

Accepted Answer

A) True 
 B)False

Question 4

Which of the following is not true about two-phased locking?

Accepted Answer

A) Can make transactions serializable 
B) Uses only shared locks 
C) Has a growing phase 
D) Has a shrinking phase 
E) Cannot obtain a new lock once a lock has been released 
A) Can make transactions serializable 
B) Uses only shared locks 
C) Has a growing phase 
D) Has a shrinking phase 
E) Cannot obtain a new lock once a lock has been released

Question 5

Processing rights may be implemented at the DBMS level.

Accepted Answer

A) True 
 B)False

Question 6

When two transactions are being processed against the database at the same time:

Accepted Answer

A) they are called concurrent transactions. 
B) they are usually interleaved. 
C) they always result in a lost update problem. 
D) one must be rolled back. 
E) A and B 
A) they are called concurrent transactions. 
B) they are usually interleaved. 
C) they always result in a lost update problem. 
D) one must be rolled back. 
E) A and B

Question 7

A standby data repository is one which requires a person to generate the metadata and place it in the repository.

Accepted Answer

A) True 
 B)False

Question 8

Which of the following would a DBA do in managing the DBMS?

Accepted Answer

A) Analyze system performance statistics 
B) Investigate user complaints 
C) Evaluate new DBMS product features 
D) Tune DBMS product options to accommodate other software in use 
E) All of the above. 
A) Analyze system performance statistics 
B) Investigate user complaints 
C) Evaluate new DBMS product features 
D) Tune DBMS product options to accommodate other software in use 
E) All of the above.

Question 9

Requiring all application programs to lock resources in the same order is one way of preventing a deadlock condition.

Accepted Answer

A) True 
 B)False

Question 10

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 11

When distributed databases break the database into sections and store the sections on different servers,this is known as:

Accepted Answer

A) replication. 
B) partitioning. 
C) disbursing. 
D) distributed two-phase locking. 
E) None of the above. 
A) replication. 
B) partitioning. 
C) disbursing. 
D) distributed two-phase locking. 
E) None of the above.

Question 12

Which of the following is true about making changes to the database structure?

Accepted Answer

A) The DBA need not get input from users on the issue because it is a technical decision. 
B) Formal policies and procedures for requesting a change are not used because they are too limiting. 
C) Documentation of when the change was made,how it was made,and why it was made must be created. 
D) Changes do not produce unexpected results because the DBA will have investigated the change thoroughly before implementing it. 
E) If the database is properly designed,changes should not be necessary throughout the system's lifetime. 
A) The DBA need not get input from users on the issue because it is a technical decision. 
B) Formal policies and procedures for requesting a change are not used because they are too limiting. 
C) Documentation of when the change was made,how it was made,and why it was made must be created. 
D) Changes do not produce unexpected results because the DBA will have investigated the change thoroughly before implementing it. 
E) If the database is properly designed,changes should not be necessary throughout the system's lifetime.

Question 13

Two-phased locking has a growing phase and a shrinking phase.

Accepted Answer

A) True 
 B)False

Question 14

Which of the following is not true about locks?

Accepted Answer

A) Locks with large granularity are easier for the DBMS to administer. 
B) Locks with small granularity cause more conflicts. 
C) Locks with large granularity produce fewer details for the DBMS to track. 
D) Locks may have a table-level granularity. 
E) Locks may have a database-level granularity. 
A) Locks with large granularity are easier for the DBMS to administer. 
B) Locks with small granularity cause more conflicts. 
C) Locks with large granularity produce fewer details for the DBMS to track. 
D) Locks may have a table-level granularity. 
E) Locks may have a database-level granularity.

Question 15

One remedy for the inconsistencies caused by concurrent processing is ________.

Accepted Answer

A) lost updates 
B) checkpointing 
C) rollback 
D) resource locking 
E) concurrency 
A) lost updates 
B) checkpointing 
C) rollback 
D) resource locking 
E) concurrency

Question 16

Measures that are taken to prevent one user's work from inappropriately influencing another user's work are called:

Accepted Answer

A) concurrency control. 
B) checkpoint. 
C) database recovery. 
D) database logging. 
E) interleaving. 
A) concurrency control. 
B) checkpoint. 
C) database recovery. 
D) database logging. 
E) interleaving.

Question 17

Locks that are placed assuming that a conflict will not occur are called:

Accepted Answer

A) dynamic. 
B) explicit. 
C) implicit. 
D) optimistic. 
E) pessimistic. 
A) dynamic. 
B) explicit. 
C) implicit. 
D) optimistic. 
E) pessimistic.

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

Which type of lock prevents all types of 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 20

In two-phase locking,all locks are released during the contracting phase.

Accepted Answer

A) True 
 B)False

Exam 9: Managing Multiuser Databases

The transaction boundaries are the essential information that the DBMS needs from the application programs to enforce different locking strategies.

Rollforward and reprocessing are two different names for the same technique.

In general,optimistic locking is the preferred technique for Internet databases.

Which of the following is not true about two-phased locking?

Processing rights may be implemented at the DBMS level.

When two transactions are being processed against the database at the same time:

A standby data repository is one which requires a person to generate the metadata and place it in the repository.

Which of the following would a DBA do in managing the DBMS?

Requiring all application programs to lock resources in the same order is one way of preventing a deadlock condition.

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

When distributed databases break the database into sections and store the sections on different servers,this is known as:

Which of the following is true about making changes to the database structure?

Two-phased locking has a growing phase and a shrinking phase.

Which of the following is not true about locks?

One remedy for the inconsistencies caused by concurrent processing is ________.

Measures that are taken to prevent one user's work from inappropriately influencing another user's work are called:

Locks that are placed assuming that a conflict will not occur are called:

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

Which type of lock prevents all types of access to the locked resource?

In two-phase locking,all locks are released during the contracting phase.

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