PostgreSQL_CE
PGCES-02 · Question #76
PostgreSQL can use an index to access a table. Select two incorrect statements about indexes.
Sign in or unlock PGCES-02 to reveal the answer and full explanation for question #76. The question stem and answer options stay visible for context.
Database Administration
Question
PostgreSQL can use an index to access a table. Select two incorrect statements about indexes.
Options
- AAn index is created by 'CREATE INDEX', and deleted by 'DROP INDEX'.
- BBy using an index effectively, searching and sorting performs faster.
- CThere are B-tree, Hash, R-tree and GiST index types.
- DBy creating an index,performance always improves.
- ECreating an unused index does not affect the performance of a database at all.
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.
Topics
#PostgreSQL indexes#index types#index performance#CREATE INDEX