Multiple choice

Which of the following tables is created to enable the building of scalable applications and is useful for large tables that can be queried or manipulated using several processes concurrently?

  1. Regular table

  2. Clustered table

  3. Partitioned table

  4. Index-organized table

Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Partitioned tables divide large datasets into smaller, more manageable pieces that can be queried or modified in parallel across multiple processes, improving performance and scalability. Regular tables (A) don't offer this parallelism, clustered tables (B) group related tables physically, and index-organized tables (D) store data within the index structure but don't inherently enable concurrent operations.