Match the following List I List II A. Secondary index I. Functional dependency…
2026
Match the following
List I | List II |
A. Secondary index | I. Functional dependency |
B. Non-procedural query language | II. B-tree |
C. Closure of a set of attribute | III. Domain calculus |
D. Natural Join | IV. Relational algebraic operation |
- A.
A – III, B – I, C – II, D – IV
- B.
A – II, B – I, C – III, D – IV
- C.
A – III, B – II, C – IV, D – I
- D.
A – II, B – III, C – I, D – IV
Attempted by 329 students.
Show answer & explanation
Correct answer: D
The correct matching for the database concepts is A-II, B-III, C-I, D-IV.
Secondary index is commonly implemented using B-tree structures (II).
Non-procedural query language matches with Domain calculus (III).
Closure of a set of attributes is defined by Functional dependency (I).
Natural Join is classified as a Relational algebraic operation (IV).