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?

Forward only

Dynamic

Keyset

Static

Forward only

Dynamic

Keyset

Static

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
The goal of database security is to ensure that only authorized users can perform authorized activities at authorized times.

True

False

ANSWER DOWNLOAD EXAMIANS APP

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

Read committed

Serializable

Read uncommitted

Repeatable read

Read committed

Serializable

Read uncommitted

Repeatable read

ANSWER DOWNLOAD EXAMIANS APP

Managing Multiuser Databases
Which of the following occurs when a transaction rereads data and finds new rows that were inserted by a command transaction since the prior read?

Consistent read

Phantom read

Dirty read

Nonrepeatable read

Consistent read

Phantom read

Dirty read

Nonrepeatable read

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 When two transactions are being processed against the database at the same time they are termed concurrent transactions.

Managing Multiuser Databases The goal of database security is to ensure that only authorized users can perform authorized activities at authorized times.

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

Managing Multiuser Databases Which of the following occurs when a transaction rereads data and finds new rows that were inserted by a command transaction since the prior read?

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
When two transactions are being processed against the database at the same time they are termed concurrent transactions.

Managing Multiuser Databases
The goal of database security is to ensure that only authorized users can perform authorized activities at authorized times.

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

Managing Multiuser Databases
Which of the following occurs when a transaction rereads data and finds new rows that were inserted by a command transaction since the prior read?

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.