1z0-064 Real Exam Dumps DEMO

Question 1: 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.)
A. It influences the optimizer to use bitmap indexes as the estimated cost of conversion from bitmap
to rowid is reduced.
B. It influences the optimizer to use indexes instead of full table scans as the estimated cost of using
an index is reduced.
C. It influences the optimizer to always use fast full index scans as the estimated cost of using an
index is reduced.
D. It influences the optimizer to use full table scans instead of index scans as the estimated cost of
full table scan is reduced.
Correct Answer: B