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

Prepare for the Leaving Certificate Computer Science Test with a mix of flashcards and multiple choice questions, each designed to enhance learning. Discover tips and resources for success. Ace your exam with confidence!

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.

Subscribe

Get the latest from Examzify

You can unsubscribe at any time. Read our privacy policy