More DBA job interview questions and answers at
http://dba.fyicenter.com/Interview-Questions/
(Continued from previous question...)
What is meant by isolation level?
This is a key concept for any relational database. Isolation level is the manner in which locks are applied and released during a transactions. For DB@ a repeatable read holds all locks untile the transaction completes or a syncpoint is issued. For transactions using 'cursor stability' the page lock releases are issued as the cursor ' moves', i.e. as the transaction releases addressability to the records
(Continued on next question...)