SQL FOR DATABASE CONSTRUCTION

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

rows can be modified according to criteria 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.

SQL can be optimized

Greater security

Increased network traffic

Code sharing

to accomplish both of the above.

to simplify a result only.

to prevent the display of sensitive data only.

None of these

AFTER

INSTEAD OF

BEFORE

All of these

change the table data.

delete rows from the table.

change the table structure.

add rows to the table.