OCP 1Z0 053 70
来源:互联网 发布:写作软件手机版 编辑:程序博客网 时间:2024/05/17 05:04
70.You executed the following SQL statement to shrink the EMPLOYEES table segment stored in the
EXAMPLE tablespace:
ALTER TABLE employees SHRINK SPACE CASCADE;
Which statement is correct in this scenario?
A. The EMPLOYEES table will be changed to read-only mode during the shrink operation.
B. The indexes created on the EMPLOYEES table will need to be rebuilt after the shrink operation is over.
C. The shrink behavior will be cascaded to all dependent segments of the table that support a shrink
operation.
D. Data manipulation language (DML) operations will not be possible on the EMPLOYEES table during
the COMPACTION phase of the shrink operation.
Answer: C
http://docs.oracle.com/cd/E11882_01/server.112/e25494/schema.htm#ADMIN12626
The
EXAMPLE tablespace:
ALTER TABLE employees SHRINK SPACE CASCADE;
Which statement is correct in this scenario?
A. The EMPLOYEES table will be changed to read-only mode during the shrink operation.
B. The indexes created on the EMPLOYEES table will need to be rebuilt after the shrink operation is over.
C. The shrink behavior will be cascaded to all dependent segments of the table that support a shrink
operation.
D. Data manipulation language (DML) operations will not be possible on the EMPLOYEES table during
the COMPACTION phase of the shrink operation.
Answer: C
http://docs.oracle.com/cd/E11882_01/server.112/e25494/schema.htm#ADMIN12626
The
CASCADE
clause extends the segment shrink operation to all dependent segments of the object. For example, if you specify CASCADE
when shrinking a table segment, all indexes of the table will also be shrunk. (You need not specify CASCADE
to shrink the partitions of a partitioned table.) To see a list of dependent segments of a given object, you can run the OBJECT_DEPENDENT_SEGMENTS
procedure of the DBMS_SPACE
package. 0 0
- OCP 1Z0 053 70
- OCP 1Z0 053 1
- OCP 1Z0 053 2
- OCP 1Z0 053 3
- OCP 1Z0 053 4
- OCP 1Z0 053 5
- OCP 1Z0 053 6
- OCP 1Z0 053 7
- OCP 1Z0 053 8
- OCP 1Z0 053 9
- OCP 1Z0 053 10
- OCP 1Z0 053 11
- OCP 1Z0 053 12
- OCP 1Z0 053 13
- OCP 1Z0 053 14
- OCP 1Z0 053 15
- OCP 1Z0 053 16
- OCP 1Z0 053 17
- Q6.6
- CSS border实现三角形
- 【DZX修改】根据性别不同显示不同的默认头像
- Android添加单元测试的方法与步骤
- Swift中文教程(十) 属性
- OCP 1Z0 053 70
- LeetCode | Median of Two Sorted Arrays(两个数组的中位数)
- 用Canvas制作可以根据手势摆动的树
- String系列源码解析02 - AbstractStringBuilder详细介绍
- Oracle获取执行计划方法
- php字符串加解密
- 数字三角形--- 动态规划入门
- mailcore -- IMAP
- POJ-2528-Mayor's posters(线段树)