Drop a single table from cluster - Database deletes each row of table - Oracle Clusters

Q.  When you drop a single table from a cluster, the database deletes which row of the table?
- Published on 27 Jul 15

a. Column data
b. Row data
c. Each row
d. Only deletes few data

ANSWER: Each row
 

    Discussion

  • Nirja Shah   -Posted on 02 Sep 15
    - When you drop a single table from a cluster, the database deletes each row of the table individually.

    - To maximize efficiency when you intend to drop an entire cluster, drop the cluster including all tables by using the DROP CLUSTER statement with the INCLUDING TABLES clause.

    - Drop an individual table from a cluster (using the DROP TABLE statement) only if you want the rest of the cluster to remain.

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