Question 1

The DBA has to find a balance between the conflicting goals of maximizing availability of the database to users and protecting the database.

Accepted Answer

A) True 
 B)False

Question 2

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 3

Copies of each database record or page after it was changed by a transaction that are saved for use in database recovery are called ghost images.

Accepted Answer

A) True 
 B)False

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

According to ANSI SQL,the serializable isolation level will not allow phantom reads,dirty reads,and nonrepeatable reads.

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

With optimistic locking,the assumption is made that no conflict will occur.

Accepted Answer

A) True 
 B)False

Question 9

A dynamic cursor saves primary key values when the cursor is opened and retrieves the values for each row as the application program accesses it.

Accepted Answer

A) True 
 B)False

Question 10

Explain the concept of serializable transactions.

Accepted Answer

Concurrent transactions are two or more

Question 11

Explain the purpose of transaction logs and checkpoints.

Accepted Answer

Transaction logs are created to facilita

Question 12

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 13

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 14

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 15

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

Accepted Answer

A) True 
 B)False

Question 16

The database is most vulnerable to failure after a change to its structure.

Accepted Answer

A) True 
 B)False

Question 17

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 18

In regard to database security,neither the DBMS nor the database applications can enforce processing responsibilities.

Accepted Answer

A) True 
 B)False

Question 19

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 20

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

Exam 9: Managing Multiuser Databases

The DBA has to find a balance between the conflicting goals of maximizing availability of the database to users and protecting the database.

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

Copies of each database record or page after it was changed by a transaction that are saved for use in database recovery are called ghost images.

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

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

According to ANSI SQL,the serializable isolation level will not allow phantom reads,dirty reads,and nonrepeatable reads.

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

With optimistic locking,the assumption is made that no conflict will occur.

A dynamic cursor saves primary key values when the cursor is opened and retrieves the values for each row as the application program accesses it.

Explain the concept of serializable transactions.

Explain the purpose of transaction logs and checkpoints.

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

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

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

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

The database is most vulnerable to failure after a change to its structure.

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

In regard to database security,neither the DBMS nor the database applications can enforce processing responsibilities.

Recovering a database via reprocessing involves:

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

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