Oracle
1Z0-882 · Question #100
Consider the structure of the table countryLanguage and the distribution of the column Is official. DESCRIBE CountryLanguage; SELECT Isofficial, COUNT (Isofficial) FROM CountryLanguage GROUP BY…
The correct answer is C. The optimizer will not choose the index on the Isofficial column. E. The speed of INSERT statements to this table will be reduced. See the full explanation below for the reasoning.
Question
Consider the structure of the table countryLanguage and the distribution of the column Is official. DESCRIBE CountryLanguage; SELECT Isofficial, COUNT (Isofficial) FROM CountryLanguage GROUP BY Isofficial; You add an index on the Isofficial column. Which two statement are true?
Exhibit
Options
- AThe optimizer will choose the index when Isofficial='T' is in the WHERE clause.
- BThe optimizer will choose the index when Isofficial='F' is in the WHERE clause.
- CThe optimizer will not choose the index on the Isofficial column.
- DThe speed of INSERT statements to this table will be improved.
- EThe speed of INSERT statements to this table will be reduced.
- FThe speed of INSERT statements to this table will be unchanged.
How the community answered
(43 responses)- A9% (4)
- B5% (2)
- C84% (36)
- F2% (1)
Community Discussion
No community discussion yet for this question.