DatabaseManagementSystem
August 29, 2024DatabaseManagementSystem
August 29, 2024Transactions
Question 29

To schedules are said to be______. If the order of any two conflicting operations is same in both the schedules.
conflict equivalent


schema equivalent


result equivalent


view equivalent

Question 29 Explanation:
Viewserializability of a schedule is defined by equivalence to a serial schedule (no overlapping transactions) with the same transactions, such that respective transactions in the two schedules read and write the same data values (“view” the same data values).
Conflictserializability is defined by equivalence to a serial schedule (no overlapping transactions) with the same transactions, such that both schedules have the same sets of respective chronologically ordered pairs of conflicting operations (same precedence relations of respective conflicting operations).
Conflictserializability is defined by equivalence to a serial schedule (no overlapping transactions) with the same transactions, such that both schedules have the same sets of respective chronologically ordered pairs of conflicting operations (same precedence relations of respective conflicting operations).
Correct Answer: A
Question 29 Explanation:
Viewserializability of a schedule is defined by equivalence to a serial schedule (no overlapping transactions) with the same transactions, such that respective transactions in the two schedules read and write the same data values (“view” the same data values).
Conflictserializability is defined by equivalence to a serial schedule (no overlapping transactions) with the same transactions, such that both schedules have the same sets of respective chronologically ordered pairs of conflicting operations (same precedence relations of respective conflicting operations).
Conflictserializability is defined by equivalence to a serial schedule (no overlapping transactions) with the same transactions, such that both schedules have the same sets of respective chronologically ordered pairs of conflicting operations (same precedence relations of respective conflicting operations).
Subscribe
Login
0 Comments