Creating cluster index - Conditions - Oracle Clusters

Q.  To create a cluster index, one of the following conditions must be true?
- Published on 13 Aug 15

a. Your schema contains the cluster
b. You have the CREATE ANY INDEX system privilege
c. Your schema does not contain cluster
d. You don’t have the CREATE ANY INDEX system privilege
e. Both A & B

ANSWER: Both A & B
 

    Discussion

  • Nirja Shah   -Posted on 02 Sep 15
    - Use the CREATE CLUSTER statement to create a cluster.

    - A cluster is a schema object that contains data from one or more tables, all of which have one or more columns in common.

    - Oracle Database stores together all the rows from all the tables that share the same cluster key.

    - Oracle Database does not automatically create an index for a cluster when the cluster is initially created.

    - Data manipulation language (DML) statements cannot be issued against cluster tables in an indexed cluster until you create a cluster index with a CREATE INDEX 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.)