UGC NET CSE | Junet 2015 | Part 2 | Question: 19

Question

Database application were directly built on top of file system to overcome the following drawbacks of using file-systems:

1. Data redundancy and inconsistency
2. Difficulty in accessing data
3. Data isolation
4. Integrity problems

• A. $\text{i}$
• B. $\text{i and iv}$
• C. $\text{i, ii, and iii}$
• D. $\text{i, ii, iii, and iv}$

Answer 1

Ans is D

Traditional file system has all mentioned drawbacks . Database applications built by using tables are used to overcome them

e,g Normalization and integrity constraints reduces redundancy and inconsistency

     select * .... from Table provide easy access to data

    References , joins etc removes data isolation

   primary and foreign key along with check predicate solves integrity problems