December2015 Cs Q14
0. Match the following database terms to their functions:
| List I | List II |
| (a) Normalization | (i) Enforces match of primary key to foreign key |
| (b) Data Dictionary | (ii) Reduces data redundancy in a databae |
| (c) Referential Integrity | (iii) Define view(s) of the database for particular user(s) |
| (d) External Schema | (iv) Contains metadata describing database structure. |
(a) (b) (c) (d) (A) (iv) (iii) (i) (ii) (B) (ii) (iv) (i) (iii) (C) (ii) (iv) (i) (iii) (D) (iv) (iii) (ii) (i)
- Option : B
- Explanation :
- Normalization reduces data redundancy in a database
- Data Dictionary contains metadata describing database structuredefines view(s) of the database for particular user(s)
- Referential Integrity enforces match of primary key to foreign key
- External Schema defines view(s) of the database for particular user(s)
