Which two statements is true regarding the above command?

Previous Question
Next Question

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.)

Exam 1Z0-047 - Which two statements is true regarding the above command?

A.
The FIRST_NAME column would be dropped provided it does not contain any data.

B.
The FIRST_NAME column would be dropped provided at least one or more columns remain in the table.

C.
The FIRST_NAME column can be rolled back provided the SET UNUSED option is added to the above SQL statement.

D.
The FIRST_NAME column can be dropped even if it is part of a composite PRIMARY KEY provided the
CASCADE option is used.

Previous Question
Next Question

Comments 1

Leave a Reply

Your email address will not be published. Required fields are marked *