2.8f

What is the purpose of the INSERT INTO statement in SQL?

It is used to add data to specific columns in a table.

What happens if a column is assigned a NULL value while there is a NOT NULL constraint?

The insert statement is rejected.

What does the DEFAULT keyword do in a CREATE TABLE statement?

It allows the specification of a default value for a column.

What is the function of the SET clause in an UPDATE statement?

It specifies the new values for specified columns.

What happens if you omit the WHERE clause in an UPDATE statement?

All rows in the table will be updated.

What does the TRUNCATE command do?

It deletes all rows from a table.

How is TRUNCATE different from DELETE?

TRUNCATE does not have a WHERE clause and may function differently depending on the database system.

What is the syntax for a TRUNCATE command?

TRUNCATE TABLE Tablename.

What keyword is used in SQL to remove rows from a table?

DELETE.

What is the effect of using the FROM keyword in a DELETE statement?

It specifies the table name from which rows are to be deleted.