Oracle Exam 1Z0-909 Topic 9 Question 23 Discussion

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

Question #: 23
Topic #: 9

Examine this statement which has executed successfully:

AExecution performance can be improved by using like instead of RLIKE.

BThe statement takes advantage of index description_idx.

CExecution performance can be improved by, using a composite index with column description as the leftmost prefix column description.

DNo index will improve statement performance.

EExecution performance can be improved by adding an index on column description.

Show Suggested Answer

Suggested Answer: D

by Jenelle at Aug 06, 2023, 04:59 PM

Limited Time Offer

25%

Off

Get Premium 1Z0-909 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Cassie

1 months ago

Haha, if you add an index on the description column, it would just be a duplicate of the existing index. E is just silly.

upvoted 0 times

...

Lenna

1 months ago

This query is already running efficiently, so D is the correct answer. No need to add any more indexes.

upvoted 0 times

...

Goldie

1 months ago

A composite index with description as the leftmost column could potentially be more efficient, but the current index is already being used, so C is not the best answer.

upvoted 0 times

Maynard

4 days ago

B) The statement takes advantage of index description_idx.

upvoted 0 times

...

Levi

5 days ago

A) Execution performance can be improved by using like instead of RLIKE.

upvoted 0 times

...

Jeannetta

22 days ago

A) Execution performance can be improved by using like instead of RLIKE.

upvoted 0 times

...

Jenifer

2 months ago

The index description_idx is being used, so B is the correct answer.

upvoted 0 times

Zena

12 days ago

So, we can conclude that the correct answer is B.

upvoted 0 times

...

Shizue

14 days ago

So, we can conclude that the statement is optimized for performance with the current index.

upvoted 0 times

...

Kami

21 days ago

Yes, you're right. Using the index description_idx is improving the execution performance.

upvoted 0 times

...

Ming

27 days ago

I think B is the correct answer because the statement is taking advantage of index description_idx.

upvoted 0 times

...

Mitsue

27 days ago

Yes, you're right. Using the index description_idx improves execution performance.

upvoted 0 times

...

Ruth

1 months ago

I think B is the correct answer because the statement takes advantage of index description_idx.

upvoted 0 times

...

Louvenia

2 months ago

The RLIKE operator is more efficient than the LIKE operator for regular expression matching, so A is not correct.

upvoted 0 times

Lucina

1 months ago

E) Execution performance can be improved by adding an index on column description.

upvoted 0 times

...

Fausto

1 months ago

C) Execution performance can be improved by, using a composite index with column description as the leftmost prefix column description.

upvoted 0 times

...

Michal

2 months ago

B) The statement takes advantage of index description_idx.

upvoted 0 times

...

Janet

2 months ago

I'm not sure, but I think option E could also be a good choice since adding an index on column description can improve execution performance.

upvoted 0 times

...

Erin

2 months ago

I agree with Billy, option C seems like the best choice for improving performance.

upvoted 0 times

...

Billy

2 months ago

I think option C is correct because using a composite index with column description as the leftmost prefix can improve execution performance.

upvoted 0 times

...