Master SQL for Data Analysis - Update and Delete

What SQL command is used to change the value of a column in specific rows of a table?

• INSERT

• SELECT

• UPDATE

• ALTER TABLE

Which SQL statement is used to rename a column in a table?

• MODIFY COLUMN

• RENAME COLUMN

• ALTER TABLE

• CHANGE COLUMN

How can you delete specific rows from a table in SQL?

• Using the DELETE command with conditions

• Using the REMOVE command

• Using the DROP command

• Using the ALTER command

What is the SQL command to remove a column from a table?

• DELETE COLUMN

• REMOVE COLUMN

• ALTER TABLE DROP COLUMN

• DROP TABLE COLUMN

Which SQL command is used to delete an entire table, including its data and metadata?

• DELETE TABLE

• ERASE TABLE

• DROP TABLE

• REMOVE TABLE