Clustered table - Definition - Oracle Tables

Q.  Which type of table is a group of tables that share the same data blocks because they share common columns and are often used together?
- Published on 28 Jul 15

a. Ordinary table
b. Partitioned table
c. Clustered table
d. Index-organized table

ANSWER: Clustered table

Related Content

 

    Discussion

  • Nirja Shah   -Posted on 01 Sep 15
    - Index-organized table - It has a storage organization that is a variant of a primary B-tree.
    - Data for an index-organized table is stored in a B-tree index structure in a primary key sorted manner.
    - Each leaf block in the index structure stores both the key and nonkey columns.

    - Ordinary table - It is also known as a heap-organized table whose data is stored as an unordered collection (heap).

    - Partitioned table - Partitioning addresses key issues in supporting very large tables and indexes by letting you decompose them into smaller and more manageable pieces called partitions. SQL queries and DML statements do not need to be modified in order to access partitioned tables.
    - Partitioning can simplify the manageability of large database objects.
    - Also, partitioning is entirely transparent to applications.

    - Clustered table - A cluster is a schema object that contains data from one or more tables, all of which have one or more columns in common.
    - Oracle Database stores together all the rows from all the tables that share the same cluster key.

➨ 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.)
▲