IBM
P2090-050 · Question #85
P2090-050 Question #85: Real Exam Question with Answer & Explanation
Sign in or unlock P2090-050 to reveal the answer and full explanation for question #85. The question stem and answer options stay visible for context.
Question
A SELECT statement spends all its time returning 1 billion rows. What can be done to make this faster?
Options
- AUse a CURSOR.
- BUse an EXTERNAL table.
- CUse the COPY command.
- DIncrease the PreFetch Count.
Unlock P2090-050 to see the answer
You've previewed enough free P2090-050 questions. Unlock P2090-050 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.