Consider two concurrent transactions on a table Department(n…
Consider two concurrent transactions on a table Department(name, budget), where each transaction is declared as Serializable and contains only read operations: T1:BEGIN TRANSACTION;Q1: SELECT MAX(salary) FROM Employee;– additional read-only queriesCOMMIT;T2:BEGIN TRANSACTION;Q2: SELECT MAX(salary) FROM Employee;– additional read-only queriesCOMMIT; Suppose both transactions T1 and T2 execute with isolation level Serializable. Consider scenarios (a), (b), (c) and (d) above for all other transactions in the system. For which of the below scenarios, if any, are we guaranteed to always get the same result for Q1 and Q2 (CHECK ALL THAT APPLY-Points deducted for incorrect checks, minimum score is zero)?