Oracle
1Z0-882 · Question #100
1Z0-882 Question #100: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-882 to reveal the answer and full explanation for question #100. The question stem and answer options stay visible for context.
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.
Unlock 1Z0-882 to see the answer
You've previewed enough free 1Z0-882 questions. Unlock 1Z0-882 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.