General information
Forum:
Microsoft SQL Server
Title:
Need an exam question explained (70-228)
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only