OCP-1Z0-053-V13.02-712新题
来源:互联网 发布:芜湖淘宝主播招聘 编辑:程序博客网 时间:2024/05/22 01:35
Why does the number of blocks for the table remain the sale after the shrink operation?
A.Because the table did not contain migrated or chained rows
B.Because the row IDs remain the same for all rows during the shrink operation
C.Because the progress of the shrink operation is not saved in the bitmap blocks of the table
D.Because the high-water mark (HWM) did not move due to the COMPACT option that is used in the shrink operation
A.Because the table did not contain migrated or chained rows
B.Because the row IDs remain the same for all rows during the shrink operation
C.Because the progress of the shrink operation is not saved in the bitmap blocks of the table
D.Because the high-water mark (HWM) did not move due to the COMPACT option that is used in the shrink operation
答案解析:
http://docs.oracle.com/cd/E11882_01/server.112/e41084/statements_3001.htm#sthref3374
COMPACT If you specify
COMPACT
, then Oracle Database only defragments the segment space and compacts the table rows for subsequent release. The database does not readjust the high water mark and does not release the space immediately. You must issue another ALTER
TABLE
... SHRINK
SPACE
statement later to complete the operation. This clause is useful if you want to accomplish the shrink operation in two shorter steps rather than one longer step. 选D。
1 0
- OCP-1Z0-053-V13.02-712新题
- OCP-1Z0-053-V13.02-1题
- OCP-1Z0-053-V13.02-682题
- OCP-1Z0-053-V13.02-687题
- OCP-1Z0-053-V13.02-692题
- OCP-1Z0-053-V13.02-696题
- OCP-1Z0-053-V13.02-711题
- OCP-1Z0-053-V13.02-710题
- OCP-1Z0-053-V13.02-709题
- OCP-1Z0-053-V13.02-708题
- OCP-1Z0-053-V13.02-706题
- OCP-1Z0-053-V13.02-490题
- OCP-1Z0-053-V13.02-24题
- OCP-1Z0-053-V13.02-36题
- OCP-1Z0-053-V13.02-43题
- OCP-1Z0-053-V13.02-45题
- OCP-1Z0-053-V13.02-60题
- OCP-1Z0-053-V13.02-651题
- Android 手机屏幕是否被锁上了
- FreeMarker模板文件的组成及基本语法详解
- Storm集群搭建
- PHP面试技巧之口试题 大家可以看看
- WPF:属性触发器
- OCP-1Z0-053-V13.02-712新题
- 怎么在PPT添加备注(只有自己看到)
- 【转载】图解winform打包程序
- 【古语】之豁达
- MAPGIS K9 基础平台培训讲义 —— 数据编辑
- MAPGIS K9基础平台培训讲义——数据管理
- 2012年CS开发暑期培训代码
- Oracle Hint用法总结
- MapGIS更改某图层里的简单要素类