Schema objects elements - Oracle Architecture

Discussion

• Nirja Shah   -Posted on 26 Aug 15
  -A schema is a collection of logical structures of data, or schema objects.
  
  -A schema is owned by a database user and has the same name as that user.
  
  -Each user owns a single schema.
  
  -Schema objects can be created and manipulated with SQL and include the following types of objects:
  
  - Index - It is a structure used to help to retreive data more quickly and efficiently
  
  -Clusters - It is a set of tables physically stored together as one table that shares a common column.
  
  -Tables - It is where data is put into organized format in the form of columns and rows.

➨ Post your comment / Share knowledge