Multiple choice

Which of the following keywords is different from others in terms of functionality?

  1. Insert

  2. Delete

  3. Alter

  4. Update
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

The alter keyword is used to alter (modify) the structure of the table. It is different from the other options because it is the only option which belongs to the DDL (Data Definition Language) part of the SQL. DDL statements are those statements that are used to define or modify the structure of the table. SQL statements like Create and Alter are DDL statements because they work on the structure of the table rather than the data.

Keep practicing — related questions