PrepAway - Latest Free Exam Questions & Answers

Which statement about insert time clustering tables (ITC) is true?

Which statement about insert time clustering tables (ITC) is true?

PrepAway - Latest Free Exam Questions & Answers

A.
Rows of an ITC table are clustered by the time they are inserted into the table.

B.
If an ITC table is clustered by one or more user specified dimensions, the specified
dimensions must be timestamps.

C.
ITC tables cannot be range-partitioned tables.

D.
ITC tables are supported in DB2 pureScale environments.

Explanation:

One Comment on “Which statement about insert time clustering tables (ITC) is true?

  1. Chow, Kenneth KY says:

    Insert time clustering (ITC) tables
    These types of tables are conceptually, and physically similar to MDC tables, but rather than being clustered by one or more user specified dimensions, rows are clustered by the time they are inserted into the table. ITC tables can be partitioned tables.
    ITC tables are not supported in a DB2 pureScale environment.




    0



    0

Leave a Reply