Question 1

An exclusive lock locks the item from change but not from read access.

Accepted Answer

A) True 
 B)False

Question 2

A passive data repository is preferred over an active repository because it requires less human intervention.

Accepted Answer

A) True 
 B)False

Question 3

Processing responsibilities should be documented and encoded into manual procedures.

Accepted Answer

A) True 
 B)False

Question 4

A dirty read happens when one transaction reads a changed record that has not been committed to the database.

Accepted Answer

A) True 
 B)False

Question 5

In two-phase locking,all locks are obtained during the growing phase.

Accepted Answer

A) True 
 B)False

Question 6

In general,the overall responsibility of the DBA is to facilitate the development and use of the database system.

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

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

Question 8

An active data repository is one in which the metadata is automatically created as the system components are created.

Accepted Answer

A) True 
 B)False

Question 9

Which of the following is allowed by "Repeatable Read Isolation"?

Accepted Answer

A) Nonrepeatable reads 
B) Dirty reads 
C) Phantom reads 
D) A and B 
E) A,B and C 
A) Nonrepeatable reads 
B) Dirty reads 
C) Phantom reads 
D) A and B 
E) A,B and C

Question 10

Changes in the database structure usually involve only one application.

Accepted Answer

A) True 
 B)False

Question 11

A durable transaction is one for which all committed changes are permanent.

Accepted Answer

A) True 
 B)False

Question 12

What are objects,and how are they related to the object-oriented DBMS (OODBMS)?

Accepted Answer

An object-oriented DBMS is designed to s

Question 13

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 14

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 15

A "database save" is used to mark the end of a transaction.

Accepted Answer

A) True 
 B)False

Question 16

Which of the following is not true of DBMS security features?

Accepted Answer

A) Users may be assigned to one or more roles. 
B) A role may be assigned to only one user. 
C) Both users and roles can have many permissions. 
D) Objects have many permissions. 
E) Each permission pertains to one user or role and one object. 
A) Users may be assigned to one or more roles. 
B) A role may be assigned to only one user. 
C) Both users and roles can have many permissions. 
D) Objects have many permissions. 
E) Each permission pertains to one user or role and one object.

Question 17

A transaction is a series of actions to be taken on the database such that either all of them are performed successfully or none of them is performed at all.

Accepted Answer

A) True 
 B)False

Question 18

Recovering a database via reprocessing 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) recreating the database by reentering 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) recreating the database by reentering 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 19

The goal of database security is to ensure that only authorized users can perform authorized activities at authorized times.

Accepted Answer

A) True 
 B)False

Question 20

Explain the process of using optimistic locking.

Accepted Answer

Optimistic locking makes the assumption

Exam 9: Managing Multiuser Databases

An exclusive lock locks the item from change but not from read access.

A passive data repository is preferred over an active repository because it requires less human intervention.

Processing responsibilities should be documented and encoded into manual procedures.

A dirty read happens when one transaction reads a changed record that has not been committed to the database.

In two-phase locking,all locks are obtained during the growing phase.

In general,the overall responsibility of the DBA is to facilitate the development and use of the database system.

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

An active data repository is one in which the metadata is automatically created as the system components are created.

Which of the following is allowed by "Repeatable Read Isolation"?

Changes in the database structure usually involve only one application.

A durable transaction is one for which all committed changes are permanent.

What are objects,and how are they related to the object-oriented DBMS (OODBMS)?

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

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

A "database save" is used to mark the end of a transaction.

Which of the following is not true of DBMS security features?

A transaction is a series of actions to be taken on the database such that either all of them are performed successfully or none of them is performed at all.

Recovering a database via reprocessing involves:

The goal of database security is to ensure that only authorized users can perform authorized activities at authorized times.

Explain the process of using optimistic locking.

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