CIS 336 STUDY It's Your Life/cis336study.com CIS 336 STUDY It's Your Life/cis336study.com | Page 20
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)
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)