Oracle OCP 082知识
剩余时间:
第 18 题 (多选题):
Which three statements are true about indexes and their administration in an Oracle database.
A. An INVISIBLE index is not maintained when Data Manipulation Language (DML) is performed on its underlying table.
B. A descending index is a type of function-based index.
C. An index can be created as part of a CREATE TABLE statement.
D. If a query filters on an indexed column then it will always be used during execution of the query.
E. A UNIQUE and non-unique index can be created on the same table column.
F. A DROP INDEX statement always prevents updates to the table during the drop operation.
显示答案
正确答案:
C,E,F
解析:
上一题
下一题
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