correct answerWhich SQL statement is used to change the data type of an existing column in a table?OptionsMODIFY COLUMNCHANGE COLUMNALTER COLUMNUPDATE COLUMN

The correct answer is ALTER COLUMN.

Here is a step-by-step guide on how to use it:

1. First, you need to use the ALTER TABLE statement to specify the table that you want to modify.

2. After that, you use the ALTER COLUMN statement to specify the column that you want to change.

3. Then, you specify the new data type for the column.

Here is an example:

ALTER TABLE table_name
ALTER COLUMN column_name TYPE new_data_type;

In this example, table_name is the name of the table, column_name is the name of the column that you want to change, and new_data_type is the new data type that you want to set for the column.