Which SQL statement correctly adds a VECTOR column named "v" with 4 dimensions and FLOAT32 format to an existing table named "my_table"?

To add a new column to an existing table, Oracle uses the ALTER TABLE statement with the ADD

clause. Option B, ALTER TABLE my_table ADD (v VECTOR(4, FLOAT32)), correctly specifies the column

name "v", the VECTOR type, and its attributes (4 dimensions, FLOAT32 precision) within parentheses,

aligning with Oracle’s DDL syntax for VECTOR columns. Option A uses MODIFY, which alters existing

columns, not adds new ones, making it incorrect here. Option C uses UPDATE, a DML statement for

updating data, not a DDL operation for schema changes. Option D omits parentheses around the

VECTOR specification, which is syntactically invalid as Oracle requires dimensions and format to be

enclosed. The SQL Language Reference confirms this syntax for adding VECTOR columns.

Reference:Oracle Database 23ai SQL Language Reference, Section on ALTER TABLE.