在oracle中创建如下表和索引，以下能使用上索引的SQL有哪些？ create table test as select * from dba_objects; create index ind_test_sub_name on test(substr(object_name,1,3)); A select * from test where subsrt(object_name,1,3)='TES'; B select * from test where subsrt(object_name,0,3)='TES'; C select * from test where subsrt(object_name,1,2)='TE'; D select * from test where subsrt(object_name,1, 3)='TES'; E select * from test where subsrt(OBJECT_NAME,1,3)='TES';