Exam 6: Database Administration

A point of synchronization between the database and the transaction log is called a(n)________.

When Microsoft Access 2016 secures a database with just a password,the database file will be a(n)________.

Generally,the more restrictive the transaction isolation level,the less the throughput of database processing.

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 not a means of processing databases?

Briefly explain the strategy of two-phased locking.

The simplest and most feasible means of recovering a database is through reprocessing.

One advantage of optimistic locking is that the lock is obtained only after the transaction is processed.

Transaction results are kept in a(n)________,which contains records of the data changes in chronological order.

When Microsoft Access 2016 compiles VBA code in a database,the resulting file is stored using a(n)________ file extension.

The purpose of concurrency control is to ________.

What is the least restrictive isolation level that will prevent phantom read problems?

Database administrators must make sure that ________ measures are in place and enforced so that only authorized users can take authorized actions at appropriate times.

Which type of lock assumes that no conflicts will occur?

Distinguish between reprocessing and rollforward as database recovery techniques.

Microsoft Access 2016 databases can be secured by deploying databases packaged with digital signatures.

Whether a lock applies to data at the record level,page level,table level,or database level is referred to as ________.

Statement level consistency means that all statements within a transaction will access consistent rows across the lifetime of the entire transaction.