Schema objects elements - Oracle Architecture

Q.  What do the schema objects comprise of?
- Published on 12 Aug 15

a. Table
b. Index
c. Cluster
d. All of the above

ANSWER: All of the above
 

    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


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)