CompTIA ITF+ Certification Practice Exams 2026 - Free ITF+ Practice Questions and Study Guide

The SQL command used to change existing data values in a table is the UPDATE command. This command specifically allows you to modify one or more records in a database table. When using UPDATE, you can set new values for specific columns in the rows that meet a certain condition, which is defined by the WHERE clause.

For example, if you have a table of customer information and you want to update the address of a specific customer, you would use the UPDATE command, specifying the table name, the columns you wish to change, and the criteria to identify which rows to update.

In contrast, the other commands have distinct purposes that do not pertain to modifying existing data. The ALTER command is used to change the structure of a database table, such as adding or removing columns or changing data types. The INSERT command is used to add new records to a table, and the CREATE command is employed to create new tables or database objects. Therefore, the correct choice for changing existing data in a table is UPDATE.