Multiple choice technology databases

Specify the actions, one can perform with ALTER TABLE statement. Choose all that apply.

  1. UPDATE the records in the table

  2. MODIFY the data type of the column

  3. DROP the table column

  4. DEFINE a default value for the column

  5. DELETE the records in the table

  6. ADD a new column to the table
Reveal answer Fill a bubble to check yourself
B,C,D,F Correct answer
Explanation

The ALTER TABLE statement in SQL allows modifications to a table's structure, including modifying column data types (MODIFY), removing columns (DROP), setting defaults (ALTER/MODIFY), and adding columns (ADD). It does not manipulate table records; UPDATE and DELETE are distinct DML operations.

Keep practicing — related questions