The size of a lock is called: shared lock implicit lock lock granularity exclusive lock TRUE ANSWER : ? YOUR ANSWER : ?
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 Static Keyset TRUE ANSWER : ? YOUR ANSWER : ?
Which of the following locks the item from access of any type? Exclusive lock Shared lock Explicit lock Implicit lock TRUE ANSWER : ? YOUR ANSWER : ?
A transaction in which either all of the database actions occur or none of them do is called: isolated. consistent. atomic. durable. TRUE ANSWER : ? YOUR ANSWER : ?
An exclusive lock locks the item from change but not from read. False True TRUE ANSWER : ? YOUR ANSWER : ?
The overall responsibility of the DBA is to facilitate the development and use of the database. False True TRUE ANSWER : ? YOUR ANSWER : ?
In optimistic locking, the assumption is made that conflict will occur. True False TRUE ANSWER : ? YOUR ANSWER : ?
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? Phantom read Nonrepeatable read Consistent read Dirty read TRUE ANSWER : ? YOUR ANSWER : ?
Which of the following occurs when a transaction rereads data it has previously read and finds modification or deletions caused by a committed transaction? Consistent read Dirty read Nonrepeatable read Phantom read TRUE ANSWER : ? YOUR ANSWER : ?