Question

Which keyword is used to remove one or more rows from a table?

1) DELETE
2) INSERT
3) ERASE
4) SET
5) UPDATE

Answer 1

The keyword used to remove one or more rows from an SQL table is DELETE. It is part of the SQL command that specifies which rows to remove based on certain conditions, and should be used with caution to avoid unintentional data loss.

Step-by-step explanation:

The keyword used to remove one or more rows from a table in SQL is the DELETE keyword. The DELETE statement allows you to specify conditions to determine which rows should be removed. For instance, if you want to remove all records from a table where the 'age' is greater than 20, you could write:

DELETE FROM table_name WHERE age > 20;

It's important to be careful when using the DELETE command as it will permanently remove data from your table. Other options provided in the question such as INSERT, ERASE, SET, and UPDATE serve different functions. INSERT is used to add new rows, ERASE is not a standard SQL keyword, SET is used in the context of updating data, and UPDATE is used to modify existing rows in a table.