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

Dynamic

Keyset

Forward only

Static

Dynamic

Keyset

Forward only

ANSWER DOWNLOAD EXAMIANS APP

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

Create and populate tables

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

Facilitate the development and use of the database

Both the first and third answers above are correct.

Create and populate tables

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

Facilitate the development and use of the database

Both the first and third answers above are correct.

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?

Nonrepeatable read

Dirty read

Consistent read

Phantom read

Nonrepeatable read

Dirty read

Consistent read

Phantom read

ANSWER DOWNLOAD EXAMIANS APP

Managing Multiuser Databases
A cursor type in which the application sees the data as they were at the time the cursor was opened is called:

dynamic

forward only

keyset

static

dynamic

forward only

keyset

static

ANSWER DOWNLOAD EXAMIANS APP

Managing Multiuser Databases
Locks placed by command are called ________ .

shared locks

implicit locks

exclusive locks

explicit locks

shared locks

implicit locks

exclusive locks

explicit locks

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

Phantom read

Consistent read

Dirty read

Nonrepeatable read

Phantom read

Consistent read

Dirty read

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 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 cursor type in which the application sees the data as they were at the time the cursor was opened is called:

Managing Multiuser Databases Locks placed by command are called ________ .

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
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
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 cursor type in which the application sees the data as they were at the time the cursor was opened is called:

Managing Multiuser Databases
Locks placed by command are called ________ .

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