Oracle OCP 082知识
剩余时间:
第 70 题 (多选题):
Examine this command SQL> ALTER TABLE ORDERS SHRINK SPACE COMPACT.Which two statements are true.
A. Queries and DML statements are allowed on ORDERs while the SHRINK is executing.
B. Dependent indexes become UNUSABLE.
C. The SHRINK operation causes rows to be moved to empty space starting toward the end of the ORDERs segment.
D. The SHRINK operation causes rows to be moved to empty space starting from the beginning of the ORDERs segment.
E. Only queries are allowed on ORDERs while the SHRINK is executing.
F. The high-water mark(HWM)of ORDERs is adjusted
显示答案
正确答案:
A,D
解析:
上一题
下一题
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80