Question 1

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 2

Discuss the DBMS security model.

Accepted Answer

In the DBMS security model,users are ass...

Question 3

One important reason for documenting changes to the database structure is for diagnosing errors.

Accepted Answer

A) True 
 B)False

Question 4

Which of the following is true of forward only cursors?

Accepted Answer

A)  Current values for each row are retrieved when the application accesses a row.
B)  All changes of any type from any source are visible.
C)  Changes made by the transaction are visible only if they occur on rows ahead of the cursor.
D)  It requires the greatest overhead of any cursor type.

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

Locks that are placed assuming that a conflict will occur are called ________.

Accepted Answer

A)  explicit locks
B)  implicit locks
C)  optimistic locks
D)  pessimistic locks

Question 7

Database administration is more important but less difficult in multiuser database systems than in single-user database systems.

Accepted Answer

A) True 
 B)False

Question 8

Copies of each database record or page before being changed by a transaction that are saved for use in database recovery are called before images.

Accepted Answer

A) True 
 B)False

Question 9

Which of the following is true about making changes to the database structure?

Accepted Answer

A)  The DBA need not get input from users on the issue because it is a technical decision.
B)  Formal policies and procedures for requesting a change are not used because they are too limiting.
C)  Documentation of when the change was made,how it was made,and why it was made must be created.
D)  Changes do not produce unexpected results because the DBA will have investigated the change thoroughly before implementing it.

Question 10

Locks with large granularity are easy for the DBMS to administer but frequently cause conflicts.

Accepted Answer

A) True 
 B)False

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

Explain the concept of serializable transactions.

Accepted Answer

Concurrent transactions are two or more ...

Question 13

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)  Both A and B are correct

Question 14

Briefly define the three problems that can occur because of concurrent processing that are addressed by resource locking.

Accepted Answer

The three problems that can occur becaus...

Question 15

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

A transaction is a group of alternative database actions,from which the database can choose to perform only one of them.

Accepted Answer

A) True 
 B)False

Question 17

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 18

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

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

Resources are locked for a shorter amount of time with pessimistic locking because the transaction is pre-processed.

Accepted Answer

A) True 
 B)False

Exam 9: Managing Multiuser Databases

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

Recovering a database via rollback involves ________.

Correct AnswerverifiedShow Answer

Which of the following is true about making changes to the database structure?

Correct AnswerverifiedShow Answer

Database administration is more important but less difficult in multiuser database systems than in single-user database systems.

Correct AnswerverifiedShow Answer

Briefly define the three problems that can occur because of concurrent processing that are addressed by resource locking.

Correct AnswerverifiedThe three problems that can occur becaus...View AnswerShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Explain the concept of serializable transactions.

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

Discuss the DBMS security model.

Correct AnswerverifiedIn the DBMS security model,users are ass...View AnswerShow Answer

Locks that are placed assuming that a conflict will occur are called ________.

Correct AnswerverifiedShow Answer

Copies of each database record or page before being changed by a transaction that are saved for use in database recovery are called before images.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Which of the following is true of forward only cursors?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

One important reason for documenting changes to the database structure is for diagnosing errors.

Correct AnswerverifiedShow Answer

Resources are locked for a shorter amount of time with pessimistic locking because the transaction is pre-processed.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Locks with large granularity are easy for the DBMS to administer but frequently cause conflicts.

Correct AnswerverifiedShow Answer

A transaction is a group of alternative database actions,from which the database can choose to perform only one of them.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
The three problems that can occur becaus...
View Answer

Correct Answer
verified

Correct Answer
verified

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

Correct Answer
verified
In the DBMS security model,users are ass...
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

Correct Answer
verified

Correct Answer
verified