PostgreSQL_CE
PGCES-02 · Question #73
PGCES-02 Question #73: Real Exam Question with Answer & Explanation
Sign in or unlock PGCES-02 to reveal the answer and full explanation for question #73. The question stem and answer options stay visible for context.
Question
Select two correct statements from below concerning the ANALYZE command.
Options
- AIt renews the statistical information of the table content.
- BIt takes some time to execute, but it does not lock the table.
- CIf the FULL option is used when executing, the size of the file can be reduced.
- DIf ANALYZE isinsufficient, the most efficient search plan will not be selected for queries.
- EIf ANALYZE is not used atall, there are times when it becomes impossible to see any of the
Unlock PGCES-02 to see the answer
You've previewed enough free PGCES-02 questions. Unlock PGCES-02 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.