Exam 6: Database Administration

A dirty read is a problem with concurrent processing when a transaction rereads data it has already read and finds modifications or deletions caused by another transaction.

When Microsoft Access 2013 secures a database with just a password,the database file will be a(n):

Breaking hardware,power outages,and human mistakes are all reasons that ________.

Distinguish between reprocessing and rollforward as database recovery techniques.

The term DBA refers to the:

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

Which of the following is not true of database recovery through reprocessing?

Explain the concept of an "atomic transaction."

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

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

The recovery technique in which the database is returned to a known state and then all valid transactions are reapplied to the database is known as:

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

Transactions should be written to the log before they are applied to the database itself.

Distinguish between statement-level consistency and transaction-level consistency.

What are the four transaction isolation levels?

What is the least restrictive isolation level that will prevent dirty reads?

Which type of lock assumes that no conflicts will occur?

Only large database systems have a need for database administration.

What database administration functions help bring order to the potential chaos of the database processing environment?

Microsoft Access 2013 uses a user-level security system.