Isds 402 Ch 6

Front 1

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:

Back 1

rollforward.

Front 2

Ensuring that each SQL statement independently processes consistent rows is known as:

Back 2

statement level consistency.

Front 3

An ACID transaction is one that is:

Back 3

All of these (isolated, consistent, atomic, durable)

Front 4

When distributed databases break the database into sections and store the sections on different servers, this is known as:

Back 4

partitioning.

Front 5

What concurrent processing problem occurs when a transaction reads a changed record that has not been committed to the database?

Back 5

Dirty reads.

Front 6

The purpose of concurrency control is to:

Back 6

ensure that one user's work does not interfere with another's.

Front 7

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

Back 7

False

Front 8

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

Back 8

Repeatable Read

Front 9

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

Back 9

False

Front 10

Preventing multiple applications from obtaining copies of the same record when the record is about to be changed is called:

Back 10

resource locking.

Front 11

When distributed databases create copies of the database on different servers, this is known as

Back 11

replication.

Front 12

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

Back 12

checkpoint

Front 13

When using the Microsoft Access 2010 Security Options dialog box, the default setting in the dialog box enables some specific capabilities of Access 2010

Back 13

False

Front 14

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

Back 14

Read Committed

Front 15

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

Back 15

Reprocessing will always return the database to its exact previous state.

Front 16

Which of the following is not a means of processing databases?

Back 16

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)

Front 17

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:

Back 17

atomic.

Front 18

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

Back 18

Serializable.

Front 19

When Microsoft Access 2010 compiles VBA code in a database, the database file will be a(n):

Back 19

*.accde file.

Front 20

The term DBA refers to the:

Back 20

database adminstrator.

Front 21

Which type of lock assumes that no conflicts will occur?

Back 21

Optimistic locks

Front 22

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

Back 22

True.

Front 23

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?

Back 23

Phantom reads.

Front 24

Which of the following is true about a shared lock?

Back 24

It allows reads to the locked item.

Front 25

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

Back 25

lock granularity.