Examice

Exam 1z0-908 All QuestionsBrowse all questions from this exam

Go to Exam

Question 1

Examine this statement, which executes successfully:

You want to improve the performance of this query:

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

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

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

ALTER TABLE world.city ADD INDEX (Population);

ALTER TABLE world.city ADD INDEX (Name);

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

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

Correct Answer: C

To improve the performance of a query that filters based on a range of integer values, adding an index on the column involved in the WHERE clause is effective. In this case, adding an index on the Population column will enable the database to locate the rows corresponding to the specified range more efficiently. A SPATIAL INDEX is not appropriate here because Population is an integer type and spatial indexes are designed for geometrical data types. Thus, the correct change to improve query performance is to add an index on the Population column.

Discussion

LrnsTghOption: C

agree with C. running command line option B generated error 1687: A SPATIAL index may only contain a geometrical type column.

nkanike1Option: C

Answer should be C

MohindarOption: C

Answer must be C, int is not spatial column

HSongOption: B

SPATIAL INDEX creates an R-tree index. For storage engines that support nonspatial indexing of spatial columns, the engine creates a B-tree index. A B-tree index on spatial values is useful for exact-value lookups, but not for range scans. The optimizer can use spatial indexes defined on columns that are SRID-restricted. So answer is B.

fthusaOption: C

Answer C

RicoAndriolOption: C

population is INT

NelateOption: C

Correct answer should be C . You can't add a spartial index on non-geo data types