Question

Match List-I with List-II:

List-I	List-II
(A) Controlled Data Sharing	(I) Same data maintained in different places does not match
(B) Data Isolation	(II) Limited Access given to users
(C) Data Dependence	(III) There is no mapping between two files
(D) Data Inconsistency	(IV) If the structure of a file is changed, all the existing programs accessing that file also need to be changed

• (A) - (II), (B) - (III), (C) - (IV), (D) - (I)
• (A) - (II), (B) - (III), (C) - (I), (D) - (IV)
• (A) - (IV), (B) - (II), (C) - (III), (D) - (I)
• (A) - (III), (B) - (IV), (C) - (I), (D) - (II)

Answer 1

The Correct Option is A

The correct matching of database concepts is (A) - (II), (B) - (III), (C) - (IV), (D) - (I).

Additional Context:

• (A) Controlled Data Sharing: (II) Limited Access given to users
  • Implemented through GRANT/REVOKE permissions
  • Example: HR can view salaries but other departments cannot
• (B) Data Isolation: (III) No mapping between two files
  • Occurs when applications manage their own files
  • Databases solve this with unified schema
• (C) Data Dependence: (IV) Program changes needed when file structure changes
  • Problematic in file systems
  • Databases provide logical/physical independence
• (D) Data Inconsistency: (I) Same data differs across locations
  • Caused by uncontrolled redundancy
  • Solved via database normalization
• Database Advantages:
  • ACID properties prevent inconsistency
  • Views enable controlled sharing

Correct Answer: (1) (A) - (II), (B) - (III), (C) - (IV), (D) - (I).