Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

Locks that are placed assuming that a conflict will occur are called ________.

Accepted Answer

A) explicit locks 
B) implicit locks 
C) optimistic locks 
D) pessimistic locks 
A) explicit locks 
B) implicit locks 
C) optimistic locks 
D) pessimistic locks

Question 3

The DBA is responsible for managing changes to the database structure,but is rarely involved in the original design of the structure.

Accepted Answer

A) True 
 B)False

Question 4

Database administration is more important but less difficult in multiuser database systems than in single-user database systems.

Accepted Answer

A) True 
 B)False

Question 5

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 6

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

Accepted Answer

A) True 
 B)False

Question 7

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 
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

Question 8

Two-phased locking is a scheme for achieving serializability of transactions.

Accepted Answer

A) True 
 B)False

Question 9

Database administration tasks have to be performed for single-user,personal databases.

Accepted Answer

A) True 
 B)False

Question 10

Discuss the DBMS security model.

Accepted Answer

In the DBMS security model,users are ass

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

Resources are locked for a shorter amount of time with pessimistic locking because the transaction is pre-processed.

Accepted Answer

A) True 
 B)False

Question 13

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) Both A and B are correct 
A) they are called concurrent transactions 
B) they are usually interleaved 
C) they always result in a lost update problem 
D) Both A and B are correct

Question 14

Copies of each database record or page before being changed by a transaction that are saved for use in database recovery are called before images.

Accepted Answer

A) True 
 B)False

Question 15

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 16

Explain the concept of serializable transactions.

Accepted Answer

Concurrent transactions are two or more

Question 17

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 18

A checkpoint is a point of synchronization between the database and the transaction log.

Accepted Answer

A) True 
 B)False

Question 19

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) 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) It requires the greatest overhead of any cursor type.

Question 20

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. 
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.

Exam 9: Managing Multiuser Databases

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

Locks that are placed assuming that a conflict will occur are called ________.

The DBA is responsible for managing changes to the database structure,but is rarely involved in the original design of the structure.

Database administration is more important but less difficult in multiuser database systems than in single-user database systems.

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

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

Recovering a database via rollback involves ________.

Two-phased locking is a scheme for achieving serializability of transactions.

Database administration tasks have to be performed for single-user,personal databases.

Discuss the DBMS security model.

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

Resources are locked for a shorter amount of time with pessimistic locking because the transaction is pre-processed.

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

Copies of each database record or page before being changed by a transaction that are saved for use in database recovery are called before images.

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

Explain the concept of serializable transactions.

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

A checkpoint is a point of synchronization between the database and the transaction log.

Which of the following is true of forward only cursors?

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

Introduction

Introduction to Structured Query Language

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 2014

Managing Databases With Oracle Database

Managing Databases With Mysql 5.6

The Web Server Environment

Big Data, Data-Warehouses, and Business Intelligence Systems

Getting Started With 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 Netbeans IDE

Business Intelligence Systems

Big Data

Filters