Alter an existing cluster - Physical attributes (INITRANS and storage characteristics) - Oracle Clusters

Q.  You can alter an existing cluster to change which of the following settings?
- Published on 04 Aug 15

a. Physical attributes (INITRANS and storage characteristics)
b. The average amount of space is not required to store all the rows for a cluster key value (SIZE)
c. There is no default degree of parallelism
d. All mentioned above
e. None of the above

ANSWER: Physical attributes (INITRANS and storage characteristics)
 

    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.

    - To alter a cluster, your schema must contain the cluster or you must have the ALTER ANY CLUSTER system privilege. You can alter an existing cluster to change the following settings:

    1. Physical attributes (INITRANS and storage characteristics)

    2. The average amount of space required to store all the rows for a cluster key value (SIZE)

    3. The default degree of parallelism

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