HASHKEYS value up to nearest Prime Number - Oracle Clusters

Q.  For maximum distribution of rows in a hash cluster, the database rounds the HASHKEYS value up to the nearest _________ .

- Published on 12 Aug 15

a. Prime Number
b. ODD Number
c. Null
d. None of the above

ANSWER: Prime Number
 

    Discussion

  • Nirja Shah   -Posted on 02 Sep 15
    - The database rounds the HASHKEYS value up to the nearest prime number, so this cluster has a maximum of 503 hash key values, each of size 512 bytes.

    - The SINGLE TABLE clause is valid only for hash clusters.

    - HASHKEYS must also be specified.

    - Prime numbers - A prime number (or a prime) is a natural number greater than 1 that has no positive divisors other than 1 and itself.

    - ODD numbers - Any integer (not a fraction) that cannot be divided exactly by 2 is known as an odd number.

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