Oracle
1Z0-909 · Question #26
1Z0-909 Question #26: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-909 to reveal the answer and full explanation for question #26. The question stem and answer options stay visible for context.
Performance
Question
Examine the appointments table definition which contains one million rows: Now, examine this statement which executes successfully: Which statement will improve query performance?
Exhibits
Options
- AALTER TABLE appointments add index IX_4<attendant_id, payment, credit)
- 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)
Unlock 1Z0-909 to see the answer
You've previewed enough free 1Z0-909 questions. Unlock 1Z0-909 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#Composite Index Design#Query Optimization#Index Selectivity#Performance Tuning