Managing Multiuser Databases What is the overall responsibility of the DBA? 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 Both the first and third answers above are correct. Development, operation, and maintenance of the database and its applications ANSWER DOWNLOAD EXAMIANS APP
Managing Multiuser Databases A durable transaction is one in which all committed changes are permanent. True False True False ANSWER DOWNLOAD EXAMIANS APP
Managing Multiuser Databases The advantage of optimistic locking is that: the lock is obtained only after the transaction has processed. the lock never needs to be obtained. transactions that are best suited are those with a lot of activity. the lock is obtained before the transaction has processed. the lock is obtained only after the transaction has processed. the lock never needs to be obtained. transactions that are best suited are those with a lot of activity. the lock is obtained before the transaction has processed. 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 keyset forward only static dynamic keyset forward only 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 True False ANSWER DOWNLOAD EXAMIANS APP
Managing Multiuser Databases In this instance, dirty reads are disallowed, while nonrepeatable reads and phantom reads are allowed. Read committed Repeatable read Serializable Read uncommitted Read committed Repeatable read Serializable Read uncommitted ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS