Oracle

1Z0-147 · Question #35

How can you migrate from a LONG to a LOB data type for a column?

The correct answer is D. D. Use the ALTER TABLE command. See the full explanation below for the reasoning.

Question

How can you migrate from a LONG to a LOB data type for a column?

Options

AA. Use the DBMS_MANAGE_LOB.MIGRATE procedure.
BB. Use the UTL_MANAGE_LOB.MIGRATE procedure.
CC. Use the DBMS_LOB.MIGRATE procedure.
DD. Use the ALTER TABLE command.
EE. You cannot migrate from a LONG to a LOB data type for a column.

How the community answered

(33 responses)

B
6% (2)
C
3% (1)
D
79% (26)
E
12% (4)

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion

Full 1Z0-147 Practice