A DBA adds an index and moves a table to a faster disk, and no application program or conceptual schema has to change. Which property does this demonstrate?
Correct answer D. Physical data independence
Explanation
Physical data independence means the internal (physical) schema, such as file organisation and indexes, can change without altering the conceptual schema or the programs built on it. Logical data independence is the harder goal of changing the conceptual schema, for example splitting a table, without breaking external views. Adding indexes is a purely physical change, so it is the physical form.
Answer checked How we write and check questions
Discussion