SQL FOR DATABASE CONSTRUCTION QUIZ

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

columns and rows only.

complicated SQL syntax only.

None of these

MAKE TABLE

DEFINE TABLE

CREATE TABLE

ALTER TABLE

True

False

pseudofile

embedded SELECT statement

None of these

trigger

False

True

False

True

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

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

rows can be modified according to criteria only.

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

False

True

is not an SQL statement.

deletes the table structure only.

works whether or not referential integrity constraints would be violated.

deletes the table structure along with the table data.

delete rows from the table.

add rows to the table.

change the table structure.

change the table data.