In DBMS architecture, what does the term 'physical data independence' refer to?
Practice Questions
Q1
In DBMS architecture, what does the term 'physical data independence' refer to?
The ability to change the logical schema without changing the physical schema
The ability to change the physical storage without affecting the logical schema
The ability to access data from multiple sources
The ability to enforce security measures
Questions & Step-by-Step Solutions
In DBMS architecture, what does the term 'physical data independence' refer to?
Correct Answer: Physical data independence
Step 1: Understand that data is stored in a database in two main ways: physically and logically.
Step 2: The physical storage refers to how data is actually stored on the hardware (like hard drives).
Step 3: The logical schema refers to how data is organized and structured in the database (like tables and relationships).
Step 4: Physical data independence means you can change how data is stored physically (like moving it to a different hard drive) without changing how the data is organized logically.
Step 5: This allows database administrators to optimize storage without affecting how users interact with the data.
