Appropriate tables for Cluster - Oracle Clusters

Q.  Which of the following conditions are true when you choose the appropriate tables for the Cluster?
- Published on 12 Aug 15

a. The tables are primarily queried--that is, tables that are not predominantly inserted into or updated
b. Records from the tables are frequently queried together or joined
c. Records from the tables are not frequently queried together or joined
d. Both A & C
e. Both A & B

ANSWER: Both A & B
 

    Discussion

  • Nirja Shah   -Posted on 02 Sep 15
    - A cluster provides an optional method of storing table data.

    - A cluster is made up of a group of tables that share the same data blocks.

    - The tables are grouped together because they share common columns and are often used together.

    - Use clusters for tables for which the following conditions are true:

    1. The tables are primarily queried--that is, tables that are not predominantly inserted into or updated.

    2. Records from the tables are frequently queried together or joined.

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