What behavior should you expect?

You are tasked to analyze blocking behavior of the following query:
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
WITH
Customers AS (SELECT * FROM Customer ),
SalesTotal AS (SELECT CustomerId, SUM(OrderTotal) AS AllOrderTotal FROM SalesOrder)
SELECT CustomerId, AllOrderTotal FROM SalesTotal WHERE AllOrderTotal > 10000.00;
You need to determine if other queries that are using the Customer table will be blocked by this query.
You also need to determine if this query will be blocked by other queries that are using the Customer table.
What behavior should you expect?
A. The other queries will not be blocked by this query.This query will not be blocked by the other queries.
B. The other queries will be blocked by this query.This query will not be blocked by the other queries.
C. The other queries will not be blocked by this query.This query will be blocked by the other queries.
D. The other queries will be blocked by this query.This query will be blocked by the other queries.

microsoft-exams

Leave a Reply

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


The reCAPTCHA verification period has expired. Please reload the page.