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?

Dynamic

Static

Forward only

Keyset

Dynamic

Static

Forward only

Keyset

ANSWER DOWNLOAD EXAMIANS APP

Managing Multiuser Databases
Locks placed by the DBMS are called ________ .

explicit locks

shared locks

implicit locks

exclusive locks

explicit locks

shared locks

implicit locks

exclusive locks

ANSWER DOWNLOAD EXAMIANS APP

Managing Multiuser Databases
Which of the following occurs when a transaction rereads data it has previously read and finds modification or deletions caused by a committed transaction?

Phantom read

Nonrepeatable read

Dirty read

Consistent read

Phantom read

Nonrepeatable read

Dirty read

Consistent read

ANSWER DOWNLOAD EXAMIANS APP

Managing Multiuser Databases
The size of a lock is referred to as lock sizing.

False

True

ANSWER DOWNLOAD EXAMIANS APP

Managing Multiuser Databases
When two transactions are being processed against the database at the same time they are termed concurrent transactions.

True

False

ANSWER DOWNLOAD EXAMIANS APP

Managing Multiuser Databases
Dirty read, nonrepeatable, and phantom reads are not possible in this instance.

Repeatable read

Read committed

Read uncommitted

Serializable

Repeatable read

Read committed

Read uncommitted

Serializable

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 Locks placed by the DBMS are called ________ .

Managing Multiuser Databases Which of the following occurs when a transaction rereads data it has previously read and finds modification or deletions caused by a committed transaction?

Managing Multiuser Databases The size of a lock is referred to as lock sizing.

Managing Multiuser Databases When two transactions are being processed against the database at the same time they are termed concurrent transactions.

Managing Multiuser Databases Dirty read, nonrepeatable, and phantom reads are not possible in this instance.

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
Locks placed by the DBMS are called ________ .

Managing Multiuser Databases
Which of the following occurs when a transaction rereads data it has previously read and finds modification or deletions caused by a committed transaction?

Managing Multiuser Databases
The size of a lock is referred to as lock sizing.

Managing Multiuser Databases
When two transactions are being processed against the database at the same time they are termed concurrent transactions.

Managing Multiuser Databases
Dirty read, nonrepeatable, and phantom reads are not possible in this instance.