Which SQL command is used to remove one or more records from a table?

Which SQL command is used to remove one or more records from a table?

• A. INSERT
• B. DELETE
• C. UPDATE
• D. SELECT

Answer: (B)

The SQL command used to remove one or more records from a table is DELETE. This command allows users to specify which records to remove based on certain conditions using a WHERE clause. If no condition is specified, all records in the table will be deleted, which is often not the desired outcome, so caution is advised. In contrast, the INSERT command is meant to add new records into a table, the UPDATE command is used for modifying existing records, and the SELECT command is utilized to retrieve data from one or more tables. Each of these commands serves a distinct purpose within SQL, making DELETE the appropriate choice for the task of removing records.

The SQL command used to remove one or more records from a table is DELETE. This command allows users to specify which records to remove based on certain conditions using a WHERE clause. If no condition is specified, all records in the table will be deleted, which is often not the desired outcome, so caution is advised.

In contrast, the INSERT command is meant to add new records into a table, the UPDATE command is used for modifying existing records, and the SELECT command is utilized to retrieve data from one or more tables. Each of these commands serves a distinct purpose within SQL, making DELETE the appropriate choice for the task of removing records.