Which clause or keyword is used to provide the list of values to insert into a table?

• A. SET
• B. Table_name
• C. SQL Alias
• D. VALUES

Answer: (D)

The VALUES clause is the part that provides the actual data to insert into a table. In an INSERT statement, you specify the target table (and optionally the columns), then use VALUES followed by the list of values in parentheses. This is how the database knows what data to put into each column.

For example: INSERT INTO employees (name, age, department) VALUES ('Alice', 30, 'HR');

You can also insert multiple rows with VALUES, like VALUES ('Bob', 25, 'IT'), ('Carol', 28, 'Finance').

The other options don’t fit because SET is used with UPDATE to change existing rows, the table name is the destination, not a data source, and SQL Alias is just a temporary name for readability, not a mechanism to supply values.