- A Ensuring the security of the database objects
- B Optimizing database performance for end-users and applications
- C Hiding performance optimization decisions from end-users and applications
- D Establishing access control to database objects
- Share this MCQ
Answer:
C
Explanation: Data independence in physical database design means that the decisions made for performance optimization purposes should be invisible to end-users and applications.
It ensures that the changes made at the physical level, such as storage structures and indexing, do not impact the way users and applications interact with the database.
Data independence allows for flexibility and maintainability, as the underlying physical design can be modified without affecting the logical view of the database. Click me to Read more Question & Answer of Database Concepts MCQs
Share this MCQ
Answer: C) Hiding performance optimization decisions from end-users and applications
Explanation: Data independence in physical database design means that the decisions made for performance optimization purposes should be invisible to end-users and applications.
It ensures that the changes made at the physical level, such as storage structures and indexing, do not impact the way users and applications interact with the database.
Data independence allows for flexibility and maintainability, as the underlying physical design can be modified without affecting the logical view of the database. Click me to Read more Question & Answer of Database Concepts MCQs
Share this MCQ