SQL FOR DATABASE CONSTRUCTION QUIZ

complicated SQL syntax only.

None of these

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

columns and rows only.

False

True

None of these

The VALUE constraint

The CHECK constraint

The LIMIT constraint

True

False

True

False

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.

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

A view

Query results

A relation

Just another table

False

True

FROM

GROUP BY

WHERE

ORDER BY

works whether or not referential integrity constraints would be violated.

is not an SQL statement.

deletes the table structure only.

deletes the table structure along with the table data.