Multiple choice

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

  1. one table

  2. one or more tables

  3. two or more tables

  4. atleast two tables
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

In Oracle, a cluster is a schema object that stores data from two or more tables that share one or more common columns. Tables in a cluster are physically stored together based on the shared cluster key, which improves performance for joins between these tables. A single table cannot form a cluster, and 'at least two' is less precise than 'two or more'.

Keep practicing — related questions