DROP CLUSTER is used to drop HASH cluster - Oracle Clusters

Q.  Which command is used to drop HASH cluster?
- Published on 29 Jul 15

a. DROP CLUSTER
b. DROP HASH CLUSTER
c. DROP_CLUSTER_HASH
d. DROP ANY CLUSTER

ANSWER: DROP CLUSTER

Related Content

 

    Discussion

  • Nirja Shah   -Posted on 02 Sep 15
    - A hash cluster provides an alternative to a non-clustered table with an index or an index cluster.

    - You can drop a hash cluster using the DROP CLUSTER statement:
    DROP CLUSTER emp_dept;

    - A table in a hash cluster is dropped using the DROP TABLE statement.

    - The implications of dropping hash clusters and tables in hash clusters are the same as those for dropping index clusters.

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