OCP 1Z0 052 V9.02 72
来源:互联网 发布:用java编写小程序 编辑:程序博客网 时间:2024/04/29 05:25
72.Examine the following output:
SQL> SELECT index_name,status
FROM dba_indexes
WHERE status='UNUSABLE';
INDEX_NAME STATUS
EIND UNUSABLE
Which two statements about the above index are true? (Choose two.)
A. It is ignored by the query optimizer.
B. It is not used while the index is being rebuilt.
C. The index cannot be rebuilt, and has to be re-created.
D. The index is automatically rebuilt when used the next time.
Answer: AB
dml不维护不可用索引,在进行大量dml操作前可以把索引设为不可用,以增加dml速度,待操作完成再对索引rebult
SQL> SELECT index_name,status
FROM dba_indexes
WHERE status='UNUSABLE';
INDEX_NAME STATUS
EIND UNUSABLE
Which two statements about the above index are true? (Choose two.)
A. It is ignored by the query optimizer.
B. It is not used while the index is being rebuilt.
C. The index cannot be rebuilt, and has to be re-created.
D. The index is automatically rebuilt when used the next time.
Answer: AB
dml不维护不可用索引,在进行大量dml操作前可以把索引设为不可用,以增加dml速度,待操作完成再对索引rebult
unusable index
An index that is not maintained by DML operations and is ignored by the optimizer. All indexes are usable (default) or unusable.
0 0
- OCP 1Z0 052 V9.02 72
- OCP 1Z0 052 V9.02 48
- OCP 1Z0 052 V9.02 115
- OCP 1Z0 052 V9.02 116
- OCP 1Z0 052 V9.02 117
- OCP 1Z0 052 V9.02 177
- OCP 1Z0 052 V9.02 201
- OCP-1Z0-052-V9.02-72题
- OCP-1Z0-052-V9.02-1题
- OCP-1Z0-052-V9.02-116题
- OCP-1Z0-052-V9.02-177题
- OCP-1Z0-052-V9.02-115题
- OCP-1Z0-052-V9.02-201题
- OCP-1Z0-051-V9.02-72题
- OCP-1Z0-051-V9.02-1题
- OCP-1Z0-051-V9.02-1题
- OCP-1Z0-051-V9.02-1题
- OCP-1Z0-051-V9.02-11题
- 高性能的 socket 通讯服务器(完成端口模型--IOCP)
- google 推出的下拉刷新用法 SwiftRefreshLayout
- [Oracle] 查询锁和释放锁
- 如何判断Android设备是手机还是平板?
- ARC工程使用不支持ARC的库以及非ARC工程使用ARC的库编译设置
- OCP 1Z0 052 V9.02 72
- TCP协议详解(下)
- DLX模板
- 浅谈phonegap之iOS打包上线之坎坷路
- iPhone开发初探
- 最长上升子序列模板
- 成长
- 文本抗锯齿
- 根据坐标返回具体地址的API