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

Keyset

Forward only

Dynamic

Static

Keyset

Forward only

ANSWER DOWNLOAD EXAMIANS APP

Managing Multiuser Databases
What is the overall responsibility of the DBA?

Both the first and third answers above are correct.

Development, operation, and maintenance of the database and its applications

Create and populate tables

Facilitate the development and use of the database

Both the first and third answers above are correct.

Development, operation, and maintenance of the database and its applications

Create and populate tables

Facilitate the development and use of the database

ANSWER DOWNLOAD EXAMIANS APP

Managing Multiuser Databases
In this instance, dirty reads are disallowed, while nonrepeatable reads and phantom reads are allowed.

Read committed

Serializable

Repeatable read

Read uncommitted

Read committed

Serializable

Repeatable read

Read uncommitted

ANSWER DOWNLOAD EXAMIANS APP

Managing Multiuser Databases
An ACID transaction is one that is atomic, consistent isolated, and durable.

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.

True

False

ANSWER DOWNLOAD EXAMIANS APP

Managing Multiuser Databases
The size of the lock is referred to as the lock granularity.

True

False

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 What is the overall responsibility of the DBA?

Managing Multiuser Databases In this instance, dirty reads are disallowed, while nonrepeatable reads and phantom reads are allowed.

Managing Multiuser Databases An ACID transaction is one that is atomic, consistent isolated, and durable.

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 The size of the lock is referred to as the lock granularity.

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
What is the overall responsibility of the DBA?

Managing Multiuser Databases
In this instance, dirty reads are disallowed, while nonrepeatable reads and phantom reads are allowed.

Managing Multiuser Databases
An ACID transaction is one that is atomic, consistent isolated, and durable.

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
The size of the lock is referred to as the lock granularity.