SQL FOR DATABASE CONSTRUCTION

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 inserted into a table only one at a time only.

rows can be modified according to criteria only.

Greater security

SQL can be optimized

Increased network traffic

Code sharing

to accomplish both of the above.

None of these

to simplify a result only.

to prevent the display of sensitive data only.

BEFORE

AFTER

All of these

INSTEAD OF

delete rows from the table.

change the table data.

change the table structure.

add rows to the table.