Which statement correctly identifies the Physical model?

Which statement correctly identifies the Physical model?

• A. Physical model
• B. Data Manipulation
• C. Conceptual model
• D. Logical model

Answer: (A)

The key idea here is the different levels of data modeling. The physical model is about how data is actually stored and implemented in a specific database system. It covers details like table structures, column data types, indexes, partitions, storage parameters, and other DBMS-specific choices that affect performance and storage. That’s why this option is correct: it directly describes storage and implementation aspects of the database. The other ideas don’t fit as a model focus. Data manipulation refers to the operations you perform on data (insert, update, delete, query). The conceptual model is a high-level view of what data exists and how it relates, without technical storage details. The logical model defines the structure of data (tables, keys, relationships) in a way that’s independent of a particular DBMS, without getting into physical storage specifics.

The key idea here is the different levels of data modeling. The physical model is about how data is actually stored and implemented in a specific database system. It covers details like table structures, column data types, indexes, partitions, storage parameters, and other DBMS-specific choices that affect performance and storage.

That’s why this option is correct: it directly describes storage and implementation aspects of the database. The other ideas don’t fit as a model focus. Data manipulation refers to the operations you perform on data (insert, update, delete, query). The conceptual model is a high-level view of what data exists and how it relates, without technical storage details. The logical model defines the structure of data (tables, keys, relationships) in a way that’s independent of a particular DBMS, without getting into physical storage specifics.