A Partitioned Primary Index should be used for what two reasons? (Choose two)

  1. It is the Primary Key of the table, which guarantees uniqueness

  2. It allows instantaneous dropping of old data and rapid addition of new data

  3. It avoids full table scans without the overhead of a secondary index.

  4. It places all data in a specific range on the same AMP.


Correct Option: C,D

Find more quizzes: