Google News
logo
Oracle - Interview Questions
What are the components of logical database structure in Oracle database?
The components of the logical database structure in Oracle database are :
 
Tablespaces : A database mainly contains the Logical Storage Unit called tablespaces. This tablespace is a set of related logical structures. To be precise, tablespace groups are related to logical structures together.
 
Database schema objects : A schema is a collection of database objects owned by a specific user. The objects include tables, indexes, views, stored procedures, etc. And in Oracle, the user is the account and the schema is the object. It is also possible in the database platforms to have a schema without a user specified.
Advertisement