I'm looking for some help answering an exam question for 70-228,

Question is concerning "set transaction level serializable",

You are the administrator of a SQL Server 2000 computer. The server contains
a database named Sales. Pierre reports that he cannot modify data in the
database. You use SQL Profiler to capture his activities as shown in the
exhibit.

(SQL:BatchCompleted--set transaction isolation level serializable begin
transaction select * from Products update products set UnitPrice = 18.50
where UnitPrice = 18.00 commit transaction)

You want Pierre to be able to modify data. You also want the Transact-SQL
statement to execute without compromising data integrity.

What are two possible ways to achieve this goal? (Each correct answer
represents a complete solution. Choose two.)

a. Change the isolation level of the database connection.
b. Add indexes to the Products table.
c. Remove the explicit transaction from the Transact-SQL batch.
d. Create a stored procedure to execute the Transact-SQL batch.
e. Add a cascading UPDATE trigger to the Products table

I'm leaning towards ACD, but is only supposed to be two answers
(b has no effect on locking, e makes no sense as an answer)

Please help explain this question to me...

Bob