Oracle Exam 1Z0-908 Topic 13 Question 54 Discussion

Actual exam question for Oracle's 1Z0-908 exam

Question #: 54
Topic #: 13

[All 1Z0-908 Questions]

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?

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

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

CALTER TABLE world.city ADD INDEX (Population);

DALTER TABLE world.city ADD INDEX (Name);

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

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

Show Suggested Answer

Suggested Answer: B

by Justine at May 07, 2022, 06:44 AM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

3 years ago

Correct answer is C. SPATIAL index can be created only on GEOMETRY data type.

upvoted 1 times

...