CIS 336 STUDY Great Stories/cis336study.com CIS 336 STUDY Great Stories/cis336study.com | Page 22

create table
update table
6. (TCO 6) When using the ALTER TABLE...DROP
COLUMN command, which of the following is not correct?
(Points : 4)
The command's effect on the table is permanent.
You cannot delete the last remaining column in a table.
The command deletes both the column and its contents.
The command can be used to delete multiple columns from a
table.
7. (TCO 6) Which of the following keywords can be used to
change the size, datatype, and/or default value of an existing
column? (Points : 4)
ADD
MODIFY
CHANGE
RESET
8. (TCO 7) Any type of subquery can be used in the
_________ clause of a SELECT statement. (Points : 4)
WHERE
HAVING