Question 1

Ensuring that all rows impacted by the actions of a transaction are protected from changes until the entire transaction is completed is called ________.

Accepted Answer

A)  statement level consistency
B)  optimistic locking
C)  transaction level consistency
D)  durable transactions

Question 2

Which of the following would a DBA typically NOT do in managing the DBMS?

Accepted Answer

A)  Analyze system performance statistics
B)  Install new versions of the operating system,as needed
C)  Evaluate new DBMS product features
D)  Tune DBMS product options to accommodate other software in use

Question 3

Rollforward is a method of database recovery that restores the database save and all valid transactions since the save was reapplied.

Accepted Answer

A) True 
 B)False

Question 4

Which of the following is not true about locks?

Accepted Answer

A)  Locks with large granularity are easier for the DBMS to administer.
B)  Locks with small granularity cause more conflicts.
C)  Locks may have a database-level granularity.
D)  Locks may have a table-level granularity.

Question 5

The security provided by the DBMS often has to be augmented by additional security features within the application program.

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

In general,optimistic locking is the preferred technique for Internet databases.

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

Which type of lock still allows other transactions to have read-only access to the locked resource?

Accepted Answer

A)  Exclusive lock
B)  Shared lock
C)  Explicit lock
D)  Implicit lock B

Question 10

One remedy for the inconsistencies caused by concurrent processing is ________.

Accepted Answer

A)  concurrency
B)  checkpointing
C)  rollback
D)  resource locking

Question 11

Which of the following is not a database administration responsibility of a DBA?

Accepted Answer

A)  Managing the database structure
B)  Writing the applications
C)  Managing the DBMS
D)  Maintaining the data repository

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

To support rollforward and rollback recovery,transactions must be written to a script before they are applied to the database.

Accepted Answer

A) True 
 B)False

Question 14

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 A

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

Resource locking is one remedy to the lost update problem.

Accepted Answer

A) True 
 B)False

Question 17

Recovering a database via rollforward 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

Question 18

In two-phase locking,all locks are released during the contracting phase.

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

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 A

Exam 9: Managing Multiuser Databases

Ensuring that all rows impacted by the actions of a transaction are protected from changes until the entire transaction is completed is called ________.

Correct AnswerverifiedShow Answer

Which of the following would a DBA typically NOT do in managing the DBMS?

Correct AnswerverifiedShow Answer

Rollforward is a method of database recovery that restores the database save and all valid transactions since the save was reapplied.

Correct AnswerverifiedShow Answer

Which of the following is not true about locks?

Correct AnswerverifiedShow Answer

The security provided by the DBMS often has to be augmented by additional security features within the application program.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

In general,optimistic locking is the preferred technique for Internet databases.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Which type of lock still allows other transactions to have read-only access to the locked resource?

Correct AnswerverifiedB

One remedy for the inconsistencies caused by concurrent processing is ________.

Correct AnswerverifiedShow Answer

Which of the following is not a database administration responsibility of a DBA?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

To support rollforward and rollback recovery,transactions must be written to a script before they are applied to the database.

Correct AnswerverifiedShow Answer

Recovering a database via reprocessing involves ________.

Correct AnswerverifiedA

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

Correct AnswerverifiedShow Answer

Resource locking is one remedy to the lost update problem.

Correct AnswerverifiedShow Answer

Recovering a database via rollforward involves ________.

Correct AnswerverifiedShow Answer

In two-phase locking,all locks are released during the contracting phase.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedA

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
B

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
A

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
A