Which of the following statements are CORRECT?
(A) Granularity is the size of data items in a database.
(B) Two operations in a schedule are said to be in conflict if they belong to the same transaction.
(C) Two schedules are said to be conflict equivalent if the order of any two conflicting operations is the same in both schedules.
(D) Write operations that are performed without performing the write operation are known as blind writes.
Choose the correct answer from the options given below:
Pick an option to check yourself, or open the answer below.
Show answer & explanation
Correct answer: B. (A), (B) and (C) Only
Explanation
A and C are standard definitions. D is garbled: a blind write is a write performed without first reading the item. Statement B, as printed, is wrong: conflicting operations belong to different transactions, access the same item, and at least one is a write. Every option includes B, so the keyed answer is A, B and C.More Database Management Systems questions
- Which of the following statements is/are NOT CORRECT? (A) The first record in each block of the data file is known as the actor record. (B)…
- Match List I with List IIList I List II (a) BCNF iff (I) every JD is implied by the candidate keys (b) 5NF iff (II) all underlying domains…
- Find the number of tuples obtained by applying the operation X ⟕X.S = Y.S Y (left outer join).
- The result of the operation X ⟖X.S = Y.S Y (right outer join) will be:
- Which join is used to get all the tuples of relations X and Y, with NULL values for the corresponding missing values?
- The number of tuples obtained by applying a right outer join on relations X and Y is: