Home » MCQs » DBMS MCQs » DBMS Schedule MCQs

What is TRUE about Serializable Schedule?

9. What is TRUE about Serializable Schedule?

1. In order to find non-serial schedules, the serializability of schedules is checked to ensure the transactions can run concurrently without being interfered with.
2. When the executions of the transactions have interleaving of their operations, it indicates which schedules are correct.
3. If a non-serial schedule's result equals that of its serial transactions, it will be serializable.
4. All of the above

Answer: D) All of the above

Explanation:

In case of Serializable Schedule -

1. In order to find non-serial schedules, the serializability of schedules is checked to ensure the transactions can run concurrently without being interfered with.
2. When the executions of the transactions have interleaving of their operations, it indicates which schedules are correct.
3. If a non-serial schedule's result equals that of its serial transactions, it will be serializable.