If there is a lock on an adjacent key, an insert will fail if the isol – McqOptions

MCQOPTIONS

1.	If there is a lock on an adjacent key, an insert will fail if the isolation level is set to what?
A.	committed read
B.	repeatable read
C.	share read
D.	indexed read
Answer» C. share read

Discussion

No Comment Found

Related MCQs

With database logging, where are transaction records first placed?
Which statement fragments a table as round robin?
Which of the following tools can be used to identify inefficient SQL statements without executing them?
Which statement correctly changes the next extent size?
which of the following represents a set of properties that guarantee that database transactions are processed reliably in computer science ?
Which of the following tools is used to create subscription sets and add subscription?set members to subscription sets?
Which of the following extenders allows data to be presented in a three dimensional format?
Which of the following commands will allow a Linux on iSeries administrator to quickly scan backup tapes for files saved via a tar command on a Linux system?
Which of the following DB2 data types CANNOT be used to contain the date an employee was hired?
Where is fragment information stored?