Which one of the following statements are CORRECT ? (A) Granularity is the…

Answer: Statements A and C are correct; Statements B and D are incorrect.

Explanation:

• Statement A: Granularity is the size of a data item in a database.

• Evaluation: True. Granularity describes the level of detail or size of the data units (e.g., tuple-level, page-level) used for operations like locking.

• Statement B: Two operations in a schedule are said to be in conflict if they belong to the same transaction.

• Evaluation: False. Two operations conflict when they are from different transactions, access the same data item, and at least one is a write. Operations within the same transaction do not create a conflict in this concurrency-control sense.

• Statement C: Two schedules are said to be conflict-equivalent if the order of every pair of conflicting operations is the same in both schedules.

• Evaluation: True. This is the standard definition of conflict equivalence between schedules.

• Statement D: Write operations which are performed without performing the write operation are known as Blind Writes.

• Evaluation: False / Misworded. A blind write is a write performed without first reading the current value (i.e., the transaction writes without depending on the prior value). The given wording is incorrect.

Final note: The correct set of true statements is A and C only. None of the provided answer choices exactly matches that correct set.