Oracle Database uses a hash function to generate a distribution of numeric values - Oracle Clusters

Q.  Oracle Database uses a hash function to generate a distribution of numeric values, called hash values, that are based on specific cluster key values.
- Published on 28 Jul 15

a. True
b. False

ANSWER: True
 

    Discussion

  • Nirja Shah   -Posted on 02 Sep 15
    - Oracle Database uses a hash function to generate a distribution of numeric values, called hash values, that are based on specific cluster key values.

    - The key of a hash cluster, like the key of an index cluster, can be a single column or composite key (multiple column key).

    - To find or store a row in a hash cluster, the database applies the hash function to the cluster key value of the row.

    - The resulting hash value corresponds to a data block in the cluster, which the database then reads or writes on behalf of the issued statement.

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