Oracle Exam 1Z0-909 Topic 5 Question 27 Discussion

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

Question #: 27
Topic #: 5

Examine the appointments table definition which contains one million rows:

Now, examine this statement which executes successfully:

Which statement will improve query performance?

AALTER TABLE appointments add index IX_4

BALTER TABLE appointments add index IX_1(credit,payment)

CALTER TABLE appointments add index IX_2(attendant_session_id, created_by)

DALTER TABLE appointments add index IX_3(attendant_id, created_by)

Show Suggested Answer

Suggested Answer: A

by Loren at Nov 25, 2023, 09:37 AM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!