Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

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 3

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.

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

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 6

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

Accepted Answer

A) True 
 B)False

Question 7

Changes in the database structure usually involve only one application.

Accepted Answer

A) True 
 B)False

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

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

Accepted Answer

A) True 
 B)False

Question 10

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 11

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

Question 12

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 13

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

Question 14

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.

Question 15

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 16

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 17

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

Accepted Answer

A) True 
 B)False

Question 18

Explain the process of using optimistic locking.

Accepted Answer

Optimistic locking makes the assumption ...

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

Processing responsibilities should be documented and encoded into manual procedures.

Accepted Answer

A) True 
 B)False

Exam 9: Managing Multiuser Databases

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Processing responsibilities should be documented and encoded into manual procedures.

Correct AnswerverifiedShow Answer

Recovering a database via reprocessing involves:

Correct AnswerverifiedShow Answer

Explain the process of using optimistic locking.

Correct AnswerverifiedOptimistic locking makes the assumption ...View AnswerShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Changes in the database structure usually involve only one application.

Correct AnswerverifiedShow Answer

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.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedAn object-oriented DBMS is designed to s...View AnswerShow Answer

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

Correct AnswerverifiedShow Answer

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

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

Correct Answer
verified
Optimistic locking makes the assumption ...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
An object-oriented DBMS is designed to s...
View Answer

Correct Answer
verified

Correct Answer
verified