IBM
C2090-461 · Question #16
C2090-461 Question #16: Real Exam Question with Answer & Explanation
Sign in or unlock C2090-461 to reveal the answer and full explanation for question #16. The question stem and answer options stay visible for context.
Question
When performing a Delete Request, you notice that Optim is doing a table scan even though you have specified a ey Lookup?in the AccessWhen performing a Delete Request, you notice that Optim is doing a table scan even though you have specified a ?ey Lookup?in the Access Method of the Table Access Strategy panel for the Delete Request. Why might Optim be doing a scan even though you have specified to us e a key to access the table?
Options
- AThe wrong index was chosen for the Optim Primary Key for the table.
- BThe table has a very large amount of data and the database engine has chosen a different
- CYou do not have authority in the database to specify a key to use.
- DCompare Row Contents option was not selected prior to running the Delete Request.
Unlock C2090-461 to see the answer
You've previewed enough free C2090-461 questions. Unlock C2090-461 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.