Immunity of the external schemas (or application programs) to changes in the conceptual schema is referred to as:
(A) Physical Data Independence
(B) Logical Data Independence
(C) Both (a) and (b)
(D) None of the above
Explanation: Immunity is when data at one layer is changed, it does not affect the data at another level.
Physical data independence:- if changes are made in the physical storage of schema then it will not affect the logical schema of the database.
Logical data independence:- if any changes are made in the conceptual schema then it will not affect external schema or the view level of the database.
So, option (B) is correct.
Quiz of this Question
Attention reader! Don’t stop learning now. Get hold of all the important DSA concepts with the DSA Self Paced Course at a student-friendly price and become industry ready.