SQL FOR DATABASE CONSTRUCTION

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.

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

rows can be modified according to criteria only.

Code sharing

SQL can be optimized

Greater security

Increased network traffic

None of these

to prevent the display of sensitive data only.

to accomplish both of the above.

to simplify a result only.

BEFORE

All of these

AFTER

INSTEAD OF

add rows to the table.

change the table data.

change the table structure.

delete rows from the table.