Correct option is C
In Oracle,
Logical Schema represents the mapping of entries, attributes, and relationships. It defines the structure of the database without specifying physical storage details.
Important Key Points:
1.
Logical Schema: Focuses on how data is organized and connected logically.
2.
Physical Schema: Describes the physical storage of data, such as files and tablespaces.
3.
Conceptual Schema: Represents a high-level design of the database, abstracted from implementation details.
Knowledge Booster:
·
Logical vs. Physical Schema: Logical schema deals with data relationships, while physical schema handles storage details.
·
Special Schema: Refers to predefined database schemas like SYS and SYSTEM in Oracle.
·
ER Diagrams: Often used to create logical schemas during the design phase.