Mysql 8.0 OCP认证考试原题题库整理-第3题(CUUG内部资料)

3、Choose the best answer.

Examine this statement, which executes successfully:

Mysql 8.0 OCP认证考试原题题库整理-第3题(CUUG内部资料)

You want to improve the performance of this query:

SELECT Name

FROM world.city

WHERE Population BETWEEN 1000000 AND 2000000;

Which change enables the query to succeed while accessing fewer rows?

A) ALTER TABLE world.city ADD INDEX (Name) ;

B) ALTER TABLE world.city ADD SPATIAL INDEX (Name) ;

C) ALTER TABLE world.city ADD FULLTEXT INDEX (Name) ;

D) ALTER TABLE world.city ADD FULLTEXT INDEX (Population) ;

E) ALTER TABLE world.city ADD SPATIAL INDEX (Population) ;

F) ALTER TABLE world.city ADD INDEX (Population) ;

Mysql 8.0 OCP认证考试原题题库整理-第3题(CUUG内部资料)

上一篇:Eclipse默认标签TODO,XXX,FIXME和自定义标签[转]


下一篇:Linuxx下安装软件方法汇总