SQL FOR DATABASE CONSTRUCTION QUIZ

change the table structure.

add rows to the table.

delete rows from the table.

change the table data.

True

False

Just another table

A relation

Query results

A view

pseudofile

None of these

embedded SELECT statement

trigger

True

False

False

True

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.

None of these

to prevent the display of sensitive data only.

to simplify a result only.

to accomplish both of the above.

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

rows can be modified according to criteria only.

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

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

Lists of values

Range checks

System date

Comparing one column value to another within the same table