Oracle
1Z0-082 · Question #66
Which three statements are true about dropping and unused columns in an Oracle database? (Choose three.)
The correct answer is A. A primary key column referenced by another column as a foreign key can be dropped if using the B. An UNUSED column's space is reclaimed automatically when the block containing that column is F. A column that is set to UNUSED still counts towards the limit of 1000 columns per table. See the full explanation below for the reasoning.
Manage Schema Objects
Question
Which three statements are true about dropping and unused columns in an Oracle database? (Choose three.)
Options
- AA primary key column referenced by another column as a foreign key can be dropped if using the
- BAn UNUSED column's space is reclaimed automatically when the block containing that column is
- CAn UNUSED column's space is reclaimed automatically when the row containing that column is
- DPartition key columns cannot be dropped.
- EA DROP COLUMN command can be rolled back
- FA column that is set to UNUSED still counts towards the limit of 1000 columns per table
How the community answered
(18 responses)- A72% (13)
- C6% (1)
- D6% (1)
- E17% (3)
Topics
#DROP COLUMN#UNUSED columns#column limit#partition key columns
Community Discussion
No community discussion yet for this question.