You need to update the CreateMonthlyTotalsReports() method to use database transactions.
Which code segment should you use?
A.
SqlConnection.BeginTransaction(IsolationLevel.ReadCommitted);
B.
SqlConnection.BeginTransaction(IsolationLevel.ReadUnconwited);
C.
SqlConnection.BeginTransaction(IsolationLevel.Chaos);
D.
SqlConnection.BeginTransaction(IsolationLevel.Serializable);
Explanation:
D
6
0
There is a missing requirement:
“The Create MonthlyTotalsReport() method must lock the data and prevent others from updating or inserting new rows until complete.”
Correct answer D
2
0
+1
2
0
Correct answer D
2
0