145k views
3 votes
Are logical and physical structure of oracle completely separate?
A)Yes
B)No

1 Answer

4 votes

Final answer:

The logical and physical structure of Oracle are not completely separate, but are tightly interconnected.

Step-by-step explanation:

The logical and physical structure of Oracle are not completely separate. In Oracle, the logical structure refers to the way that data is organized and stored at the conceptual level, such as tables, views, and relationships. The physical structure, on the other hand, refers to the way that data is physically stored on disk, such as data files and tablespaces.

While the logical structure provides a high-level, conceptual view of the data, the physical structure deals with the actual implementation and storage of that data. Although they are distinct concepts, the logical and physical structures of Oracle are tightly interconnected.

For example, when you create a table in Oracle, you define its logical structure by specifying the columns, data types, and constraints. However, the table's data is physically stored in data files on disk according to the physical structure defined by Oracle.

User Kenji
by
8.0k points