What should you include in the design?

You need to design a stored procedure to update rows. The stored procedure must meet the following
requirements:
If more than one row is updated, an error must be raised to the application and the update must be
discarded.
The stored procedure must be designed to maximize concurrency.
What should you include in the design? To answer, move the appropriate actions from the list of actions to the
answer area and arrange them in the correct order.
Build List and Reorder:

You need to design a stored procedure to update rows. The stored procedure must meet the following
requirements:
If more than one row is updated, an error must be raised to the application and the update must be
discarded.
The stored procedure must be designed to maximize concurrency.
What should you include in the design? To answer, move the appropriate actions from the list of actions to the
answer area and arrange them in the correct order.
Build List and Reorder:

Answer:

Show Hint

Leave a Reply 2

Your email address will not be published. Required fields are marked *

M

M

Is seriazable correct if we need to maximize concurrency? Best to leave it at default read commited (snapshot if set)?

Reply