View the Exhibit and examine the structure of the EMP table which is not partitioned and not an index- organized table. Evaluate the following SQL statement:
ALTER TABLE emp
DROP COLUMN first_name;
Which two statements is true regarding the above command? (Choose two.)
The FIRST_NAME column would be dropped provided it does not contain any data.
The FIRST_NAME column would be dropped provided at least one or more columns remain in the table.
The FIRST_NAME column can be rolled back provided the SET UNUSED option is added to the above SQL statement.
The FIRST_NAME column can be dropped even if it is part of a composite PRIMARY KEY provided the
CASCADE option is used.