SQL FOR DATABASE CONSTRUCTION

rows can be modified according to criteria only.

rows cannot be copied in mass from one table to another only.

rows can be inserted into a table only one at a time only.

rows can either be inserted into a table one at a time or in groups.

Increased network traffic

Greater security

SQL can be optimized

Code sharing

to accomplish both of the above.

to prevent the display of sensitive data only.

None of these

to simplify a result only.

INSTEAD OF

All of these

AFTER

BEFORE

add rows to the table.

change the table data.

change the table structure.

delete rows from the table.