1. |
What is the main difference between the SET UNUSED COLUMN and the DROP COLUMN clauses of the ALTER TABLE command?
Please select the best answer.
|
|
A. |
You can view the data in the unused column and you cannot view the data in a dropped column.
|
|
B. |
You free up space with DROP COLUMN (but not with SET UNUSED COLUMN ).
|
|
C. |
You can use SET UNUSED COLUMN (but not DROP COLUMN ) on a primary key column.
|
|
D. |
You can specify a list of columns with SET UNUSED COLUMN (but not with DROP COLUMN ).
|