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)