nerdexam
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)
  • A
    3% (1)
  • B
    75% (24)
  • C
    6% (2)
  • F
    16% (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.

Full 1Z0-071 Practice