Oracle
1Z0-064 · Question #41
1Z0-064 Question #41: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-064 to reveal the answer and full explanation for question #41. The question stem and answer options stay visible for context.
Question
Examine the command to change a parameter value from the default to 50: SQL> ALTER SYSTEM SET OPTIMIZER_INDEX_COST_ADJ = 50; What is the effect of changing the value of the parameter? (Choose the best answer.)
Options
- AIt influences the optimizer to use full table scans instead of index scans as the estimated cost of
- BIt influences the optimizer to use bitmap indexes as the estimated cost of conversion from bitmap
- CIt influences the optimizer to always use fast full index scans as the estimated cost of using an
- DIt influences the optimizer to use indexes instead of full table scans as the estimated cost of using
Unlock 1Z0-064 to see the answer
You've previewed enough free 1Z0-064 questions. Unlock 1Z0-064 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.