DBMS End Term: 21 December 2025 (September 2025 term)

1. A

   The query returns employees name who earn above the company-wide average salary and joined before the company’s latest hire.

2. B

   The query returns employees name who earn above the department’s average salary and joined before the most recent hire in the same department.

3. C

   The query returns employees name who earn above the department’s average salary and joined before the company’s latest hire.

4. D

   The query returns employees name who earn above the company-wide average salary and before the most recent hire in the same department.

Select all that apply.

1. A

   Schedule S1 is conflict serializable.

2. B

   Schedule S1 can be two-phase lockable.

3. C

   Schedule S2 is conflict serializable.

4. D

   Schedule S2 can be two-phase lockable.

1. A

   No transaction needs Roll Back.

2. B

   Transaction T3 needs to Roll Back.

3. C

   Transaction T2 needs to Roll Back.

4. D

   Transaction T1 needs to Roll Back.