View the Exhibit and examine the structure of the EMP table which is not partitioned and not an index-organized table. (Choose two.) 

Evaluate this SQL statement: ALTER TABLE emp - DROP COLUMN first_name; Which two statements are true? 

Answer options:

A. The FIRST_NAME column can be dropped even if it is part of a composite PRIMARY KEY provided the CASCADE option is added to the SQL statement.
B. The FIRST_NAME column would be dropped provided at least one column remains in the table.
C. The FIRST_NAME column would be dropped provided it does not contain any data.
D. The drop of the FIRST_NAME column can be rolled back provided the SET UNUSED option is added to the SQL statement.

B