Which three are true about dropping columns from a table? (Choose three.)

The correct answer is B. A column that is referenced by another column in any other table cannot be dropped. C. A column can be removed only if it contains no data. F. A primary key column cannot be dropped. https://oracle-base.com/articles/8i/dropping-columns

Managing Schema Objects

Question

Options

AA column drop is implicitly committed.
BA column that is referenced by another column in any other table cannot be dropped.
CA column can be removed only if it contains no data.
DMultiple columns can be dropped simultaneously using the ALTER TABLE command.
EA column must be set as unused before it is dropped from a table.
FA primary key column cannot be dropped.

How the community answered

(51 responses)

A
12% (6)
B
78% (40)
D
6% (3)
E
4% (2)

Explanation

https://oracle-base.com/articles/8i/dropping-columns

Topics

#ALTER TABLE#drop column#primary key#constraints

Community Discussion

No community discussion yet for this question.

Full 1Z0-071 Practice