A | B |
UPDATE | modifies existing rows in a table. |
INSERT INTO | adds a new row to a table |
ANY Operator | compares value to each value returned by the subquery. |
Explicit | fully and clearly expressed; leaving nothing implied. |
Integrity Constraint | ensures that the data adheres to a predefined set of rules. |
DELETE | removes existing rows from a table. |
Transaction | consists of a collection of DML statements that form a logical unit of work. |
ALL Operator | compares value to every value returned by the subquery. |
USER | someone doing "real work" with the computer, using it as a means rather than an end. |
IN Operator | compares if value is in the list of all values returned by the subquery. |