Exam 6: Database Administration

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

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

Standard SQL defines four ________,which specify which of the concurrency control problems are allowed to occur.

Concurrent processing of a database only poses problems when two or more processes attempt to use the same data.

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

Explain the concept of an "atomic transaction."

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

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

Two-phase locking can be used to ensure that transactions are serializable.

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

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

Serializable transactions are created by having a(n)________ phase,in which locks are obtained,and a(n)________ phase,in which locks are released.

Which type of lock assumes that no conflicts will occur?

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

Which of the following is true about a shared lock?

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