There are 3 levels of abstraction in DBMS

Physical Level

• It is the lowest level of data abstraction and is managed by DBMS.
• This level shows how the data is stored in the database.
• Data storage descriptions and details of this level are hidden from system admins, developers, and users

Logical Level

• Logical level is the second level in data abstraction, which states the type of data and the relationship among the data that is stored in the database.
• It is a level on which system admin and developers work.

View Level

• This is the highest level of data abstraction, which shows/states only a part of the database.
• View level is a level that describes a part of the database and hides the details of the table and its schema and storage from its users.
• The result of a query is an example of view-level data abstraction.
• A table created by selecting fields from one or more tables present in the database can be shown using this view.