CIS 336 All Assignments CIS 336 All Assignments | Page 17

physical
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
8. (TCO 7) Any type of subquery can be used in the _________ clause of a SELECT statement.
(Points : 4)
WHERE
HAVING
FROM
ORDER BY
GROUP