CREATE ANY CLUSTER SYSTEM privilege used to create cluster in another users schema - Oracle Clusters

Q.  Which SYSTEM privilege must be used to create a cluster in another user's schema?

- Published on 30 Jul 15

a. CREATE ANY CLUSTER
b. CREATE ANY SCHEMA CLUSTER
c. CREATE SCHEMA CLUSTER
d. CREATE CLUSTER

ANSWER: CREATE ANY CLUSTER
 

    Discussion

  • Nirja Shah   -Posted on 02 Sep 15
    - 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.

    - The following are the prerequisites of creating a cluster.

    - CREATE CLUSTER - This system privilege is used to create a cluster in your own schema.

    - CREATE ANY CLUSTER - This system privilege is used to create a cluster in another user's schema.

    - There are no system privileges such as the CREATE ANY SCHEMA CLUSTER and the CREATE SCHEMA CLUSTER.

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