Exam 1z0-071 Topic 1 Question 238 Discussion

Actual exam question for Oracle's 1z0-071 exam
Question #: 238
Topic #: 1

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?

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 drop of the FIRST_NAME column can be rolled back provided the SET UNUSED option is added to the SQL statement. C. The FIRST_NAME column would be dropped provided it does not contain any data. D. The FIRST_NAME column would be dropped provided at least one column remains in the table.

Comments

0 Happy Clients

0 Shares

0 Demo Downloads

10 Years in Business