Which statement accomplish this task?

You have a table with the following definition:
CREATE TABLE long_tab
( id NUMBER)
long_col LONG)
You need to convert the LONG_COL column from a LONG data type to a LOB data type. Which statement accomplish this task?

A.
ALTER TABLE long_tab
MODIFY (LONG_COL CLOB);

B.
EXECUTE dbms_lob.migrate(long_tab, long_col, clob)

C.
EXECUTE dbms_manage.lob.migrate(long_tab, long_col, clob)

D.
EXECUTE utl_lob.migrate(long_tab, long_col, clob)

E.
EXECUTE utl_manage_lob.migrate(long_tab, long_col, clob)

Explanation:
In Oracle 9i, a LONG column in a Table can be migrated to a LOB column using the ALTER TABLE statement. The syntax is:
ALTER TABLE &lt;schema&gt;.&lt;table name&gt;&lt;BR&gt; MODIFY <long column name> {CLOB | BLOB | NCLOB}
In Oracle 8i you must use the TO_LOB function to migrate an existing LONG column to a LOB column.
This function can only be used in the SELECT list of a subquery in an INSERT Statement.