Question 1

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 2

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

Accepted Answer

A) True 
 B)False

Question 3

Resource locking must be carefully planned because most DBMS products cannot detect a deadlock condition.

Accepted Answer

A) True 
 B)False

Question 4

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 5

Briefly explain the strategy of two-phased locking.

Accepted Answer

Two-phased locking is a strategy to ensu

Question 6

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 7

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 8

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

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

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 11

Explain the importance of documenting changes in database structure.

Accepted Answer

Changes in database structure may introd

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

Changes in the database structure usually involve only one application.

Accepted Answer

A) True 
 B)False

Question 14

Locks placed automatically by the DBMS are called implicit locks.

Accepted Answer

A) True 
 B)False

Question 15

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 16

Discuss the DBMS security model.

Accepted Answer

In the DBMS security model,users are ass

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

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 19

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

Accepted Answer

A) True 
 B)False

Question 20

Distinguish between the four cursor types.

Accepted Answer

Forward only cursors are the simplest ty

Exam 9: Managing Multiuser Databases

Recovering a database via rollback involves:

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

Resource locking must be carefully planned because most DBMS products cannot detect a deadlock condition.

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:

Briefly explain the strategy of two-phased locking.

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:

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

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

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

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

Explain the importance of documenting changes in database structure.

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

Changes in the database structure usually involve only one application.

Locks placed automatically by the DBMS are called implicit locks.

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

Discuss the DBMS security model.

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

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

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

Distinguish between the four cursor types.

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