ocp 19c考题，科目082考试题(16)-about dropping and unused columns
16.Which three statements are true about dropping and unused columns in an Oracle database?(Choose three.)
A. A primary key column referenced by another column as a foreign key can be dropped if using the CASCADE option.
B. An UNUSED column’s space is reclaimed automatically when the block containing that column is next queried.
C. An UNUSED column’s space is reclaimed automatically when the row containing that column is next queried.
D. Partition key columns cannot be dropped.
E. A DROP COLUMN command can be rolled back
F. A column that is set to UNUSED still counts towards the limit of 1000 columns per table
source : cuug
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/70010796/viewspace-2853019/ ，如需转载，请注明出处，否则将追究法律责任。
最新文章
- 从小白到专家 PG技术大讲堂 - Part 2：PG源代码安装
- 从小白到专家 PG 技术大讲堂 - Part 1：PG 简介
- ocp 19c考题，科目082考试题(34)
- ocp 19c考题，科目082考试题(33)
- ocp 19c考题，科目082考试题(32) -
- ocp 19c考题，科目082考试题(31) - resource_limit
- ocp 19c考题，科目082考试题(30) - default profile
- ocp 19c考题，科目082考试题(29) - about profiles
- ocp 19c考题，科目082考试题(28) - oracle profiles
- ocp 19c考题，科目082考试题(27) - order by clause
