SQL FOR DATABASE CONSTRUCTION QUIZ

change the table data.

delete rows from the table.

add rows to the table.

change the table structure.

False

True

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

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

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

rows can be modified according to criteria only.

Code sharing

SQL can be optimized

Greater security

Increased network traffic

True

False

False

True

Range checks

System date

Lists of values

Comparing one column value to another within the same table

False

True

False

True

complicated SQL syntax only.

columns and rows only.

None of these

both of the above can be hidden by an SQL view.