Match the following database terms to their functions : \(\begin{array} {clcl}…
2015
Match the following database terms to their functions :
\(\begin{array} {clcl} & \textbf{List – I} && \textbf{List – II} \\ \text{(a)} & \text{Normalization} & \text{(i)} & \text{Enforces match of primary key}\\ &&& \text{to foreign key} \\ \text{(b)} & \text{Data Dictionary} &\text{(ii)}& \text{Reduces data redundancy in} \\ &&& \text{a database} \\ \text{(c)} & \text{Referential Integrity} & \text{(iii)} & \text{Defines view(s) of the database for } \\ && & \text{particular user(s)} \\ \text{(d)} & \text{External Schema} & \text{(iv)} & \text{Contains metadata describing} \\ &&& \text{database structure} \\ \end{array}\)
Codes :
- A.
(a)-(iv), (b)-(iii), (c)-(i), (d)-(ii)
- B.
(a)-(ii), (b)-(iv), (c)-(i), (d)-(iii)
- C.
(a)-(ii), (b)-(iv), (c)-(iii), (d)-(i)
- D.
(a)-(iv), (b)-(iii), (c)-(ii), (d)-(i)
Attempted by 530 students.
Show answer & explanation
Correct answer: B
Correct matches and explanations:
Normalization → Reduces data redundancy in a database.
Data Dictionary → Contains metadata describing the database structure.
Referential Integrity → Enforces matching between primary key and corresponding foreign key to preserve relationships.
External Schema → Defines view(s) of the database for particular user(s).
Thus the correct matching is: Normalization → reduces data redundancy; Data Dictionary → contains metadata; Referential Integrity → enforces primary-foreign key match; External Schema → defines user views.
A video solution is available for this question — log in and enroll to watch it.