Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
25 Cards in this Set
- Front
- Back
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:
|
rollforward.
|
|
Ensuring that each SQL statement independently processes consistent rows is known as:
|
statement level consistency.
|
|
An ACID transaction is one that is:
|
All of these (isolated, consistent, atomic, durable)
|
|
When distributed databases break the database into sections and store the sections on different servers, this is known as:
|
partitioning.
|
|
What concurrent processing problem occurs when a transaction reads a changed record that has not been committed to the database?
|
Dirty reads.
|
|
The purpose of concurrency control is to:
|
ensure that one user's work does not interfere with another's.
|
|
Rollback requires the use of logs, but rollforward does not.
|
False
|
|
What is the least restrictive isolation level that will prevent nonrepeatable reads?
|
Repeatable Read
|
|
With optimistic locking, locks are first issued, then the transaction is processed, and then the locks are released.
|
False
|
|
Preventing multiple applications from obtaining copies of the same record when the record is about to be changed is called:
|
resource locking.
|
|
When distributed databases create copies of the database on different servers, this is known as
|
replication.
|
|
A point of synchronization between the database and the transaction log is called a(n):
|
checkpoint
|
|
When using the Microsoft Access 2010 Security Options dialog box, the default setting in the dialog box enables some specific capabilities of Access 2010
|
False
|
|
What is the least restrictive isolation level that will prevent dirty reads?
|
Read Committed
|
|
Which of the following is not true of database recovery through reprocessing?
|
Reprocessing will always return the database to its exact previous state.
|
|
Which of the following is not a means of processing databases?
|
All of these are means of processing a database. (Programs coded in C#, Internet applications using ASP, Internet applications using JSP, Applications invoking stored procedures)
|
|
When a transaction in such a way that either all of the transaction actions are completed or none of them will be, the transaction is said to be:
|
atomic.
|
|
What is the least restrictive isolation level that will prevent phantom read problems?
|
Serializable.
|
|
When Microsoft Access 2010 compiles VBA code in a database, the database file will be a(n):
|
*.accde file.
|
|
The term DBA refers to the:
|
database adminstrator.
|
|
Which type of lock assumes that no conflicts will occur?
|
Optimistic locks
|
|
Transactions should be written to the log before they are applied to the database itself.
|
True.
|
|
What concurrent processing problem occurs when a transaction rereads data and finds new rows that were inserted by a different transaction since the prior read?
|
Phantom reads.
|
|
Which of the following is true about a shared lock?
|
It allows reads to the locked item.
|
|
Whether a lock applies to data at the record level, page level, table level, or database level is referred to as:
|
lock granularity.
|