一天一道OBCP(来自个人语雀整理):【单选题】13. "在一个Oracle租户中,表tb1的DDL如下所示,该表上的哪个索引是全局索引?()

TABLE tb1 (id INT, name VARCHAR(30), age INT, phone VARCHAR(20), addr VARCHAR(100), PRIMARY KEY(id)) PARTITION BY HASH(id) PARTITIONS 16;CREATE INDEX i1 ON tb1 (name);CREATE index i2 ON tb1 (phone) GLOBAL;CREATE INDEX i3 ON tb1 (age) GLOBAL PARTITION BY RANGE(age) (PARTITION p0 VALUES LESS THAN(18), PARTITION p1 VALUES LESS THAN(30), PARTITION p2 VALUES LESS THAN(60), PARTITION p3 VALUES LESS THAN(MAXVALUE));"
A. i3
B. i2
C. i1
D. 全部都是

1 个赞

题目略长啊,选D吧

1 个赞

不错~