Question

In SQL, which command(s) is (are) used to change a table's storage characteristics.

A) ALTER TABLE
B) MODIFY TABLE
C) CHANGE TABLE
D) All of the above

Answer 1

In SQL, the ALTER TABLE command is used for changing a table's storage characteristics, while MODIFY TABLE and CHANGE TABLE are not standard commands for this purpose.

Step-by-step explanation:

In SQL, the command used to change a table's storage characteristics is ALTER TABLE. The ALTER TABLE command is quite versatile and allows for various changes to the structure of a table, including modifying its storage engine, adding or dropping columns, changing column types, and more. The other options such as MODIFY TABLE and CHANGE TABLE are not standard SQL commands for altering table storage characteristics.