Data Engineering Associate with Databricks Practice Exam

Which SQL command would you use to delete a record from a table?

1. REMOVE FROM

2. DELETE

3. DROP

4. EXPUNGE

The correct answer is: DELETE

The SQL command used to delete a record from a table is "DELETE." This command allows you to specify which rows in a table should be removed based on a specified condition. For example, using a command like `DELETE FROM table_name WHERE condition;` enables users to target specific records for deletion, ensuring that only the intended data is impacted. In contrast, other commands serve different purposes within SQL. "REMOVE FROM" is not a recognized standard SQL command for deleting records and is therefore not valid. "DROP" is used to remove entire database objects like tables or databases rather than individual records. "EXPUNGE" is also not a standard SQL command and does not pertain to the deletion of records in relational database systems. Understanding the correct usage of the "DELETE" command is essential for managing data within SQL databases effectively.