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 )