Which of the following refers to a cursor type that when the cursor is opened, a primary key value is saved for each row in the recordset; when the application accesses a row, the key is used to fetch the current values of the row?

Managing Multiuser Databases
Which of the following refers to a cursor type that when the cursor is opened, a primary key value is saved for each row in the recordset; when the application accesses a row, the key is used to fetch the current values of the row?

Static

Keyset

Forward only

Dynamic

Static

Keyset

Forward only

Dynamic

ANSWER DOWNLOAD EXAMIANS APP

Managing Multiuser Databases
Which of the following occurs when one transaction reads a changed record that has not been committed to the database?

Nonrepeatable read

Dirty read

Consistent read

Phantom read

Nonrepeatable read

Dirty read

Consistent read

Phantom read

ANSWER DOWNLOAD EXAMIANS APP

Managing Multiuser Databases
When one transaction reads a changed record that has not been committed to the database a filthy read occurs.

True

False

ANSWER DOWNLOAD EXAMIANS APP

Managing Multiuser Databases
The advantage of optimistic locking is that:

transactions that are best suited are those with a lot of activity.

the lock never needs to be obtained.

the lock is obtained before the transaction has processed.

the lock is obtained only after the transaction has processed.

transactions that are best suited are those with a lot of activity.

the lock never needs to be obtained.

the lock is obtained before the transaction has processed.

the lock is obtained only after the transaction has processed.

ANSWER DOWNLOAD EXAMIANS APP

Managing Multiuser Databases
Resource locking is a process to prevent multiple applications from obtaining copies of the same record when the record is about to be changed.

False

True

ANSWER DOWNLOAD EXAMIANS APP

Managing Multiuser Databases
A phantom read occurs when a transaction rereads data it has previously read and finds modifications or deletions caused by a committed transaction.

False

True

ANSWER DOWNLOAD EXAMIANS APP

Managing Multiuser Databases

Managing Multiuser Databases Which of the following refers to a cursor type that when the cursor is opened, a primary key value is saved for each row in the recordset; when the application accesses a row, the key is used to fetch the current values of the row?

Managing Multiuser Databases Which of the following occurs when one transaction reads a changed record that has not been committed to the database?

Managing Multiuser Databases When one transaction reads a changed record that has not been committed to the database a filthy read occurs.

Managing Multiuser Databases The advantage of optimistic locking is that:

Managing Multiuser Databases Resource locking is a process to prevent multiple applications from obtaining copies of the same record when the record is about to be changed.

Managing Multiuser Databases A phantom read occurs when a transaction rereads data it has previously read and finds modifications or deletions caused by a committed transaction.

Managing Multiuser Databases
Which of the following refers to a cursor type that when the cursor is opened, a primary key value is saved for each row in the recordset; when the application accesses a row, the key is used to fetch the current values of the row?

Managing Multiuser Databases
Which of the following occurs when one transaction reads a changed record that has not been committed to the database?

Managing Multiuser Databases
When one transaction reads a changed record that has not been committed to the database a filthy read occurs.

Managing Multiuser Databases
The advantage of optimistic locking is that:

Managing Multiuser Databases
Resource locking is a process to prevent multiple applications from obtaining copies of the same record when the record is about to be changed.

Managing Multiuser Databases
A phantom read occurs when a transaction rereads data it has previously read and finds modifications or deletions caused by a committed transaction.