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?

Keyset

Dynamic

Static

Forward only

Keyset

Dynamic

Static

Forward only

ANSWER DOWNLOAD EXAMIANS APP

Managing Multiuser Databases
Two transactions that run concurrently and generate results that are consistent with the results that would have occurred if they had run separately are referred to as serializable transactions.

True

False

ANSWER DOWNLOAD EXAMIANS APP

Managing Multiuser Databases
A cursor type in which the application can only move forward through the recordset is called:

keyset.

forward only.

dynamic.

static.

keyset.

forward only.

dynamic.

static.

ANSWER DOWNLOAD EXAMIANS APP

Managing Multiuser Databases
Which of the following allows dirty reads, nonrepeatable reads and phantom reads to occur?

Serializable

Read uncommitted

Repeatable read

Read committed

Serializable

Read uncommitted

Repeatable read

Read committed

ANSWER DOWNLOAD EXAMIANS APP

Managing Multiuser Databases
Locks placed by command are called ________ .

shared locks

explicit locks

implicit locks

exclusive locks

shared locks

explicit locks

implicit locks

exclusive locks

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 Two transactions that run concurrently and generate results that are consistent with the results that would have occurred if they had run separately are referred to as serializable transactions.

Managing Multiuser Databases A cursor type in which the application can only move forward through the recordset is called:

Managing Multiuser Databases Which of the following allows dirty reads, nonrepeatable reads and phantom reads to occur?

Managing Multiuser Databases Locks placed by command are called ________ .

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
Two transactions that run concurrently and generate results that are consistent with the results that would have occurred if they had run separately are referred to as serializable transactions.

Managing Multiuser Databases
A cursor type in which the application can only move forward through the recordset is called:

Managing Multiuser Databases
Which of the following allows dirty reads, nonrepeatable reads and phantom reads to occur?

Managing Multiuser Databases
Locks placed by command are called ________ .

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.