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 full table scans instead of index scans as the estimated cost of full table scan is reduced.
B.
It influences the optimizer to use bitmap indexes as the estimated cost of conversion from bitmap to rowid 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 indexes instead of full table scans as the estimated cost of using an index is reduced.
Currently there are no comments in this discussion, be the first to comment!
This section is not available anymore. Please use the main Exam Page.1z0-064 Exam Questions
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Comments