Exam 6: Database Administration

When Microsoft Access 2013 uses user-level security with an Access 2003 database file,it stores the database in a(n)________ file.

One way to prevent concurrent processing problems is to lock data that are retrieved for update.

Database security is easy to achieve since all security is handled by the DBMS,which is a single point of entry into the database.

Briefly explain the strategy of two-phased locking.

Rollback requires the use of logs,but rollforward does not.

When Microsoft Access 2013 uses user-level security with an Access 2003 file,the database is stored in a(n):

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

With optimistic locking,locks are first issued,then the transaction is processed,and then the locks are released.

The recovery method where the database is restored using the saved data,and all transactions since the save are reapplied is called ________ recovery.

Microsoft Access 2013 databases cannot be secured by password encryption.

Microsoft Access 2013 databases can be secured using trusted locations for database storage.

Computer systems fail for which of the following reasons?

Microsoft Access 2013 can secure databases by using ________ to encrypt and decrypt the database files.

One of the major tasks of the database administration is called ________ control,which allows multiple users to access the database simultaneously.

Which of the following is true about a shared lock?

The purpose of concurrency control is to: