这道题选哪个答案呢

培训 & 考证
#1

建Outline 的语句如下:多选题
CREATE FORMAT OUTLINE ot1 ON
“SELECT/+ index(t1 ix1)/C1+1,C2,C3FROM T1 WHERE C1=1”;以下哪个语句可以命中该Outline?
A.SELECT C1+2,C2,C3 FROM T1 WHERE C1=5
B.SELECT C1+1, C2, C3 FROM T1 WHERE C1=5
C.SELECT C1+1,C3,C2 FROM TI WHERE C1=5
D.SELECT C1+1,C2,C3 FROM T1 WHERE C1=199

#2

选B、D
SELECT C1+1,C2,C3 FROM T1 WHERE C1=?
顺序要一致，where后参数值可以不一样
B和D均符合！

#3

BD

1 个赞