Multiple choice

Alter command is used: (a) to delete a column in a table (b) to change the data type of a column in a table (c) to add a column in a table (d) to rename a table

  1. only a

  2. a and b

  3. a, b and c

  4. all of these

  5. none of these

Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Option 4 is the correct answer as alter statement is used to change the data type of a column in a table, to delete a column in a table, to add a column in a table and to rename a table. Syntax: ALTER TABLE table_name RENAME TO new_table_name