SQL FOR DATABASE CONSTRUCTION QUIZ

System date

Comparing one column value to another within the same table

Lists of values

Range checks

True

False

Increased network traffic

SQL can be optimized

Greater security

Code sharing

False

True

a particular column in a particular underlying table.

a particular row in a particular underlying table.

a particular column in a particular row.

None of these

To accomplish both of the above.

To save users from having to write an expression.

None of these

To ensure that the results are consistent.

False

True

SELECT VIEW

INSERT VIEW

CREATE VIEW

MAKE VIEW

pseudofile

stored procedure

trigger

None of these

True

False