UGC NET CSE | December 2015 | Part 2 | Question: 14

Question

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}$

$\textbf{Codes :}$

• A. $\text{(a)-(iv), (b)-(iii), (c)-(i), (d)-(ii)}$
• B. $\text{(a)-(ii), (b)-(iv), (c)-(i), (d)-(iii)}$
• C. $\text{(a)-(ii), (b)-(iv), (c)-(iii), (d)-(i)}$
• D. $\text{(a)-(iv), (b)-(iii), (c)-(ii), (d)-(i)}$

Answer 1

Normalization - Reduces data redundancy in a database 

Data Dictionary - Contains metadata describing database structure

Referential Integrity      -  Enforces match of primary key to foreign key 

External Schema       -  Defines view(s) of the database for particular user(s)