- A To define the logical structure of the database
- B To establish naming conventions for database objects
- C To optimize performance and scalability
- D To translate business processes into data requirements
- Share this MCQ
Answer:
C
Share this MCQ
Answer: C) To optimize performance and scalability
Explanation: The purpose of physical database design is to optimize the performance and scalability of the database system.
It involves making decisions related to storage structures, indexing, partitioning, replication, and other physical considerations to meet the performance requirements of the application.
The physical database design stage requires a deep understanding of the expected workload and the features offered by the chosen DBMS to achieve optimal performance.
Share this MCQ