Computer Science and Engineering › Database Concepts MCQs › Question #13520
Single Choice Easy

QWhat is data independence in the context of physical database design?

ID: #13520 Database Concepts MCQs 152 views
Question Info
#13520Q ID
EasyDifficulty
Database Concepts MCQsTopic
Start Quiz on This Topic
 Your Answer

Choose the Best Option

Click any option to instantly check if you're correct.

  • 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 ✔ ✖
Correct Answer

Explanation

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.

 Continue Practice
Previous Question Next Question
 Share

Share This Question

Challenge a friend or share with your study group.

 More from This Topic

Related MCQ Questions

What was MICRO Information Management System based on?... Which component of a DBMS is responsible for ensuring that the database can be recovered in case of system failures or data corruption?... What feature of a DBMS ensures that multiple users can access and modify the database concurrently without conflicts?... What is the role of terminology in a database design?... What is the primary function of a database management system (DBMS)?... A) Can a customer also be a supplier?... What is the purpose of transaction management in a DBMS?... Which approach is commonly used for replicating an entire database?... Which component of a DBMS describes the metadata and provides information about the structure and organization of the database?... Which of the following is an example of a database management system?...