CIS 336 help Making Decisions/uophelp.com CIS 336 help Making Decisions/uophelp.com | Page 17

UNIQUE
REFERENCE
CONDITION
CHECK
4. (TCO 5) The ___________ model is both software and hardware dependent. (Points :
4)
conceptual
logical
condensed
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)