Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

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.E) A) and B)
F) None of the above

Question 3

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 repositoryE) B) and D)
F) C) and D)

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

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 transactionsE) A) and B)
F) A) and C) A

Question 6

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 transactionsE) A) and C)
F) A) and B)

Question 7

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 8

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

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

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 11

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

Accepted Answer

A)  concurrency
B)  checkpointing
C)  rollback
D)  resource lockingE) All of the above
F) B) and D)

Question 12

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 lockE) C) and D)
F) All of the above B

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

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 15

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 loggingE) B) and C)
F) A) and B) A

Question 16

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 17

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 useE) A) and C)
F) B) and C)

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

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 transactionsE) B) and C)
F) None of the above

Question 20

Resource locking is one remedy to the lost update problem.

Accepted Answer

A) True 
 B)False

Exam 9: Managing Multiuser Databases

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

Correct AnswerverifiedShow Answer

Which of the following is not true about locks?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Recovering a database via reprocessing involves ________.

Correct AnswerverifiedA

Recovering a database via rollforward involves ________.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

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

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedB

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

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

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

Correct AnswerverifiedA

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Resource locking is one remedy to the lost update problem.

Correct AnswerverifiedShow Answer

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

Correct Answer
verified
B

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