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:
Which two statements are true?
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_MAME column can be rolled back provided the SET UNUSED option is added to the SQL statement.
AB
AB
AB