CIS 336 STUDY Career Begins/cis336study.com CIS 336 STUDY Career Begins/cis336study.com | Page 20
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 )
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 )