Which one of the following statements are CORRECT?

(A) Granularity is the size of data item in a database.

(B) Two operations in a schedule are said to be conflict if they belong to same transaction.

(C) Two schedulers are said to be conflict equivalent if the order of any two conflicting operations is the same in both schedules.

(D) Write operations which are performed without performing the write operation are known as Blind Writes.

Choose the correct answer from the options given below:

This question was previously asked in
UGC NET Computer Science (Paper 2) 07 Dec 2023 Official Paper
View all UGC NET Papers >
  1. (A) and (B) Only
  2. (A), (B) and (C) Only
  3. (A), (B) and (D) Only
  4. (B) and (C) Only

Answer (Detailed Solution Below)

Option 2 : (A), (B) and (C) Only
Free
UGC NET Paper 1: Held on 21st August 2024 Shift 1
10.8 K Users
50 Questions 100 Marks 60 Mins

Detailed Solution

Download Solution PDF

The correct answer is (A), (B) and (C) Only

EXPLANATION:

  • (A) Granularity is the size of a data item in a database.
    • Granularity refers to the level of detail or size of the data that is stored in a database. It can vary from fine granularity (smaller, more detailed data items) to coarse granularity (larger, less detailed data items). The statement is correct.
  • (B) Two operations in a schedule are said to be conflict if they belong to the same transaction.
    • In the context of database transactions, operations are considered conflicting if they involve the same data item and at least one of them is a write operation. The statement is correct.
  • (C) Two schedulers are said to be conflict equivalent if the order of any two conflicting operations is the same in both schedules.
    • Conflict equivalence in schedulers means that if two schedules result in the same final state, they are conflict equivalent if the order of conflicting operations (operations that access the same data item and at least one is a write operation) is the same in both schedules. The statement is correct.
  • (D) Write operations which are performed without performing the read operation are known as Blind Writes.
    • This statement is incorrect. Blind Writes typically refer to write operations performed without checking or reading the existing content. If a write operation is performed without a prior read, it doesn't necessarily make it a Blind Write.

Therefore, the correct statements are (A), (B), and (C).

Mistake PointsTwo operations in a schedule are said to be conflict if they belong to the same transaction.
In the context of database transactions, operations are considered conflicting if they involve the same data item and at least one of them is a write operation. The statement is incorrect. But it is official question and official answer consider it is correct.

Latest UGC NET Updates

Last updated on Jun 6, 2025

-> The UGC NET Exam Schedule 2025 for June has been released on its official website.

-> The UGC NET Application Correction Window 2025 is available from 14th May to 15th May 2025.

-> The UGC NET 2025 online application form submission closed on 12th May 2025.

-> The June 2025 Exam will be conducted from 21st June to 30th June 2025

-> The UGC-NET exam takes place for 85 subjects, to determine the eligibility for 'Junior Research Fellowship’ and ‘Assistant Professor’ posts, as well as for PhD. admissions.

-> The exam is conducted bi-annually - in June and December cycles.

-> The exam comprises two papers - Paper I and Paper II. Paper I consists of 50 questions and Paper II consists of 100 questions. 

-> The candidates who are preparing for the exam can check the UGC NET Previous Year Papers and UGC NET Test Series to boost their preparations.

More Transaction Questions

Get Free Access Now
Hot Links: teen patti rules teen patti real cash game teen patti wealth teen patti bindaas teen patti chart