QUESTION 1
You want to create a transaction, but you do not want anyone to modify the rows in aDataSet
object until the transaction is finished.
What isolation level should you use? (Select the best choice.)
A.
ReadCommitted
B.
ReadUncommitted
C.
RepeatableRead
D.
Serializable
Answer: D
Section: (none)
Explanation/Reference:
Section: 3. Consuming and Manipulating Data
Choice d is correct. The Serializable value of the TransactionIsolationLevel enumeration specifies
that no users should be able to add rows or modify data in a data set while a transaction is open.
The ReadCommitted value specifies that locks are placed on the data while it is being read, but
data can still be altered before the transaction is complete. No locks are held in
aReadUncommitted transaction. With RepeatableRead, a transaction will prevent others from
modifying data while a transaction is open, but phantom rows can still be created.
Reference:
MSDN, Search, "TransactionIsolationLevel Enumeration," ".NET Framework Class Library."
QUESTION 2
Your company has installed an application to a network share that will be used by several
employees. The application will be executed on individual client computers. Each computer will
use a different database when executing the application. Each computer needs to retain the name
of the database it will use in its Machine.config file.
Which of the following XML segments under the <appSettings> element in theMachine.config