External consistency ensures that the data stored in the database is:
Click on the arrows to vote for the correct answer
A. B. C. D.D.
External consistency ensures that the data stored in the database is consistent with the real world.
Source: KRUTZ, Ronald L.
& VINES, Russel.
D., The CISSP Prep Guide: Mastering the Ten Domains of Computer Security, 2001, John Wiley & Sons, page 33.
External consistency ensures that the data stored in the database is consistent with the real world. Option D, "consistent with the real world" is the correct answer.
External consistency is a concept in database design that ensures that the data stored in a database reflects the real world it represents. This means that the data must be accurate, up-to-date, and free from inconsistencies. It also means that the data must be consistent with external entities, such as other databases or applications that use the data.
External consistency is important because it ensures that the data in the database is reliable and can be used by other systems or applications without errors or inconsistencies. For example, if a database contains customer information, the data must be accurate and up-to-date to ensure that other systems or applications that use the data can do so without issues.
Option A, "inconsistent with the real world," is incorrect because this would mean that the data stored in the database does not reflect the real world it represents.
Option B, "remains consistent when sent from one system to another," is not entirely correct. While external consistency does ensure that data can be used by other systems or applications without errors or inconsistencies, it is not solely focused on data transmission between systems.
Option C, "consistent with the logical world," is not entirely correct either. While logical consistency is important in database design, external consistency specifically refers to the consistency between the data stored in the database and the real world it represents.