SQL FOR DATABASE CONSTRUCTION QUIZ

The LIMIT constraint

None of these

The CHECK constraint

The VALUE constraint

Comparing one column value to another within the same table

Lists of values

System date

Range checks

To hide rows only

All of these

To hide complicated SQL statements only

To hide columns only

False

True

AFTER

All of these

BEFORE

INSTEAD OF

False

True

True

False

CREATE VIEW

MAKE VIEW

INSERT VIEW

SELECT VIEW

None of these

To save users from having to write an expression.

To accomplish both of the above.

To ensure that the results are consistent.

False

True