CIS 336 STUDY Future Starts Here/cis336study.com CIS 336 STUDY Future Starts Here/cis336study.com | Page 20

5. (TCO 6) The _________________________ statement can
be used to enable or disable a constraint. (Points : 4)
alter table
modify table
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