IBM
A2090-614 · Question #94
What must be done to convert an existing table into an Insert-Time-Clustered (ITC) table?
The correct answer is A. Call the ADMIN_MOVE_TABLE procedure. See the full explanation below for the reasoning.
Question
What must be done to convert an existing table into an Insert-Time-Clustered (ITC) table?
Options
- ACall the ADMIN_MOVE_TABLE procedure.
- BCall the ADMIN_REVALIDATE_DB_OBJECTS procedure.
- CIssue a REORG TABLE statement with the ORGANIZE BY INSERT TIME option.
- DIssue an ALTER TABLE statement with the ORGANIZE BY INSERT TIME option.
How the community answered
(38 responses)- A71% (27)
- B18% (7)
- C3% (1)
- D8% (3)
Community Discussion
No community discussion yet for this question.