SQL FOR DATABASE CONSTRUCTION QUIZ

DEFINE TABLE

ALTER TABLE

CREATE TABLE

MAKE TABLE

False

True

True

False

True

False

None of these

To accomplish both of the above.

To ensure that the results are consistent.

To save users from having to write an expression.

Comparing one column value to another within the same table

Range checks

Lists of values

System date

a particular row in a particular underlying table.

a particular column in a particular row.

None of these

a particular column in a particular underlying table.

False

True

None of these

pseudofile

stored procedure

trigger

WHERE

ORDER BY

GROUP BY

FROM