PrepAway - Latest Free Exam Questions & Answers

What distinguishes table partitioning from projection segmentation?

What distinguishes table partitioning from projection segmentation?

PrepAway - Latest Free Exam Questions & Answers

A.
If table data is partitioned, associated projections can only be replicated.

B.
If table data is partitioned, the table cannot participate in a prejoin projection.

C.
If table data is partitioned, associated projections cannot be segmented.

D.
If table data is partitioned, associated projections can also be segmented.

Explanation:

One Comment on “What distinguishes table partitioning from projection segmentation?

  1. Sam says:

    Answer D is not correct.

    distinguished feature of partition must be B.
    If table data is partitioned, the table cannot participate in a prejoin projection.Since it requires lot of records need to be deleted because of referential integrity which must exist between the tables involved in prejoin projections.




    0



    0

Leave a Reply