Multiple choice technology web technology

The EMPLOYEE table contains info about employees. One of your employees got married , so her last name changed . What would be the command to reflect that change in the table ?

  1. UPDATE

  2. ALTER

  3. INSERT

  4. CREATE
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The UPDATE statement is used to modify existing records in a table, making it the correct command to update a married employee's last name. In contrast, ALTER modifies the table's structure (schema), INSERT adds new records, and CREATE is used to instantiate new database objects like tables.

Keep practicing — related questions