Oracle
1Z0-071 · Question #419
Which two are true about unused columns? (Choose two.)
The correct answer is B. Unused columns retain their data until they are dropped. E. A primary key column cannot be set to unused. https://decipherinfosys.wordpress.com/2007/11/15/back-to-the-basics-dropping-unused-columns-
Managing Schema Objects
Question
Which two are true about unused columns? (Choose two.)
Options
- AA query can return data from unused columns, but no DML is possible on those columns.
- BUnused columns retain their data until they are dropped.
- COnce a column has been set to unused, a new column with the same name can be added to the
- DThe DESCRIBE command displays unused columns.
- EA primary key column cannot be set to unused.
- FA foreign key column cannot be set to unused.
How the community answered
(32 responses)- A3% (1)
- B75% (24)
- C6% (2)
- F16% (5)
Explanation
https://decipherinfosys.wordpress.com/2007/11/15/back-to-the-basics-dropping-unused-columns-
Topics
#SET UNUSED#unused columns#primary key constraint#DESCRIBE command
Community Discussion
No community discussion yet for this question.