Oracle
1Z0-071 · Question #120
View the Exhibit and examine the structure of the EMP table which is not partitioned and not an index-organized table. Evaluate this SQL statement: ALTER TABLE emp DROP COLUMN first_name; Which two…
The correct answer is B. The FIRST_NAME column would be dropped provided at least one column remains in the table. D. The drop of the FIRST_NAME column can be rolled back provided the SET UNUSED option is. See the full explanation below for the reasoning.
Question
View the Exhibit and examine the structure of the EMP table which is not partitioned and not an index-organized table. Evaluate this SQL statement:
ALTER TABLE emp DROP COLUMN first_name; Which two statements are true? (Choose two.)
Exhibit
Options
- AThe FIRST_NAME column can be dropped even if it is part of a composite PRIMARY KEY
- BThe FIRST_NAME column would be dropped provided at least one column remains in the table.
- CThe FIRST_NAME column would be dropped provided it does not contain any data.
- DThe drop of the FIRST_NAME column can be rolled back provided the SET UNUSED option is
How the community answered
(54 responses)- A7% (4)
- B78% (42)
- C15% (8)
Community Discussion
No community discussion yet for this question.