nerdexam
IBM

A2090-614 · Question #94

A2090-614 Question #94: Real Exam Question with Answer & Explanation

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.

Community Discussion

No community discussion yet for this question.

Full A2090-614 Practice