创建表order_test，内有10行单列数据，其值为随机生成。建表语句如下： create table order_test as select dbms_random.value(1,100) c1 from dual connect by rownum<=10;。请问，以下哪种创建索引的方法，会导致 select /*+ index(t ind_c1) */ * from order_test t whe re cl is not null; 返回的结果是有序的？ACD A create index ind_c1 on order_test(1,c1); B create index ind_c1 on order_test(c1) global partiti on by hash(c1) partitions 2; C create index ind_c1 on order_test(c1); D create index ind_c1 on order_test(c1) global partiti on by range(c1) (partition p1 values less than(51),partition p2 values less than (101),partition p_max v alues less than(maxvalue));