Question

Which SQL keyword is used to add one or more rows to a table?

a) DELETE
b) INSERT
c) SELECT
d) SET
e) UPDATE

Answer 1

The INSERT SQL keyword is used to add new rows to a table, specifying the target table and the values for each specified column.

Step-by-step explanation:

When you want to add new data into a database table, the INSERT statement is used to specify the table into which the data should go, as well as to define the data that will be added with each corresponding column value.

Here's a basic example of how the INSERT statement is used:

INSERT INTO table_name (column1, column2, column3) VALUES (value1, value2, value3)

Note that the columns listed in the INSERT statement must be present in the table and the types of the values provided must match the data types defined for those columns.