TK上的一道题:
QUESTION NO: 106
Which two statements are true regarding partitioned tables and indexes? (Choose two)
A. A table which is part of a cluster can be partitioned.
B. A global bitmap index can be created for a partitioned table.
C. A table containing LONG or LONG RAW datatypes can be partitioned.
D. A partitioned table can have partitioned and/or non-partitioned indexes.
E. Privileges for partitions are granted on the parent table or index and not on individual partitions.
F. Rule Based Optimization is used be default when a SQL statement accesses a partitioned table or
index.
Answer: D, E
B为什么不对?
最初由 vage 发布
[B]TK上的一道题:
QUESTION NO: 106
Which two statements are true regarding partitioned tables and indexes? (Choose two)
A. A table which is part of a cluster can be partitioned.
B. A global bitmap index can be created for a partitioned table.
C. A table containing LONG or LONG RAW datatypes can be partitioned.
D. A partitioned table can have partitioned and/or non-partitioned indexes.
E. Privileges for partitions are granted on the parent table or index and not on individual partitions.
F. Rule Based Optimization is used be default when a SQL statement accesses a partitioned table or
index.
Answer: D, E
B为什么不对? [/B]
Bitmap index只能是local partition的,试着建一下你就明白了,如果建成global的会报ORA-25113错。