Managing Multiuser Databases What is the overall responsibility of the DBA? Both the first and third answers above are correct. Facilitate the development and use of the database Create and populate tables Development, operation, and maintenance of the database and its applications Both the first and third answers above are correct. Facilitate the development and use of the database Create and populate tables Development, operation, and maintenance of the database and its applications ANSWER DOWNLOAD EXAMIANS APP
Managing Multiuser Databases The size of a lock is called: exclusive lock shared lock lock granularity implicit lock exclusive lock shared lock lock granularity implicit lock 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. False True False True ANSWER DOWNLOAD EXAMIANS APP
Managing Multiuser Databases A transaction for which all committed changes are permanent is called: consistent. isolated. atomic. durable. consistent. isolated. atomic. durable. 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? Dirty read Nonrepeatable read Consistent read Phantom read Dirty read Nonrepeatable read Consistent read Phantom read ANSWER DOWNLOAD EXAMIANS APP
Managing Multiuser Databases When one transaction reads a changed record that has not been committed to the database a filthy read occurs. True False True False ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS