Practice mode DBMS and SQL

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.

Report a problem

Answer checked How we write and check questions

Tip: press A, B, C or D to answer, and N for the next question.

Advertisement

Have a question about this answer?

Your email address will not be published. Required fields are marked *

Links and website addresses are not allowed in comments.