Database programming section 12 quiz

What keyword in an update statement specifies the column that you want to change select having WHERE set?
Use the SET clause to specify a new value for each column that you want to update.
The SET clause names the columns that you want updated and provides the values that you want them changed to..
What would happen if you issued a DELETE statement without a WHERE clause?
The result of the DELETE statement is the removal of zero or more rows of a table, depending on how many rows satisfy the search condition specified in the WHERE clause.
If you omit the WHERE clause from a DELETE statement, SQL removes all the rows from the table..
Which two commands can be used to modify existing data in a database row?
Answer.
The two commands that can be used to modify existing data in a database row are UPDATE and MERGE..
DELETE deletes rows that satisfy the WHERE clause from the specified table.
If the WHERE clause is absent, the effect is to delete all rows in the table.

What keyword in an update statement specifies the column that you want to change select having WHERE set?