Oracle 1Z0-908 Exam - Topic 11 Question 113 Discussion

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

Question #: 113
Topic #: 11

[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: C

by Sarah at Mar 06, 2026, 08:07 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

4 hours ago

I practiced a similar question where adding an index on Population helped, but I wonder if it would work the same way here.

upvoted 0 times

...

5 days ago

I think adding an index on Name could improve performance, but I’m not certain if FULLTEXT is necessary for this query.

upvoted 0 times

...

10 days ago

I remember we discussed how spatial indexes can help with geographical queries, but I'm not sure if they apply to the Name column here.

upvoted 0 times

...