Skip to content

CS Professional · Artificial Intelligence, Data Analytics and Cyber Security - Laws and Practice · Database Management

A company changes the physical storage of its employee records by adding an index and moving files to a new disk, and no application programs or user views need modification. Which property of the DBMS architecture is demonstrated?

This shows physical data independence: the internal storage level, such as indexes and disk location, was changed without affecting the conceptual schema or applications. Logical data independence would instead concern changes to the conceptual schema without disturbing external views, which did not occur in this scenario.

  1. ALogical data independence
  2. BPhysical data independenceCorrect
  3. CData redundancy
  4. DReferential integrity

Explanation

Physical data independence means the internal schema can be changed, for example storage devices or indexes, without altering the conceptual schema or applications. Logical data independence is the ability to change the conceptual schema without changing external views, which is not what happened here.

Did you get it right without looking?

One question tells you little. A timed set on Database Management shows your real accuracy, how long you take and where you lose marks.

Practise Database ManagementFree diagnostic mock

More Database Management questions