Question 1

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

Question 2

Explain the purpose of transaction logs and checkpoints.

Accepted Answer

Transaction logs are created to facilita...

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

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 5

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

Accepted Answer

A) True 
 B)False

Question 6

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 7

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.

Question 8

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.

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

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.

Question 12

Explain the concept of serializable transactions.

Accepted Answer

Concurrent transactions are two or more ...

Question 13

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 14

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

Accepted Answer

A) True 
 B)False

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

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.

Question 18

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 19

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 20

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

Accepted Answer

A) True 
 B)False

Exam 9: Managing Multiuser Databases

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Recovering a database via reprocessing involves:

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Explain the concept of serializable transactions.

Correct AnswerverifiedConcurrent transactions are two or more ...View AnswerShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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.

Correct AnswerverifiedShow Answer

Explain the purpose of transaction logs and checkpoints.

Correct AnswerverifiedTransaction logs are created to facilita...View AnswerShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Concurrent transactions are two or more ...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Transaction logs are created to facilita...
View Answer