假设在DEPARTMENT表中创建如下索引：create index ind_dept_code on department(dept_code);下列哪种写法可以应用上索引范围扫描？ - 墨天轮每日一题

任务中心

2021-03-03

单选题

389人参与 · 244人答对

来自：赵勇 — 贡献 248 题

假设在DEPARTMENT表中创建如下索引：create index ind_dept_code on department(dept_code);下列哪种写法可以应用上索引范围扫描？

A

SELECT…FROM DEPARTMENT WHERE DEPT_CODE like ‘123456%'

B

SELECT…FROM DEPARTMENT WHERE DEPT_CODE like ‘%123456'

C

SELECT…FROM DEPARTMENT WHERE DEPT_CODE like ‘%123456%'

D

SELECT…FROM DEPARTMENT WHERE DEPT_CODE like ‘%123%456'

A. SELECT…FROM DEPARTMENT WHERE DEPT_CODE like ‘123456%'

B. SELECT…FROM DEPARTMENT WHERE DEPT_CODE like ‘%123456'

C. SELECT…FROM DEPARTMENT WHERE DEPT_CODE like ‘%123456%'

D. SELECT…FROM DEPARTMENT WHERE DEPT_CODE like ‘%123%456'

来自：赵勇 — 贡献 248 题

提交答案

提交答案

讨论

暂无图片

答题后参与讨论

我也要出题，获取更多墨值

扫一扫，小程序答题更便捷

微信订阅二维码

微信订阅，每日一题不错过

题目正确率排行

倒序正序