nerdexam
PostgreSQL_CE

PGCES-02 · Question #76

PostgreSQL can use an index to access a table. Select two incorrect statements about indexes.

The correct answer is D. By creating an index,performance always improves. E. Creating an unused index does not affect the performance of a database at all. PostgreSQL CE PGCES-02 Exam

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.

How the community answered

(25 responses)
  • A
    4% (1)
  • B
    8% (2)
  • C
    4% (1)
  • D
    84% (21)

Explanation

PostgreSQL CE PGCES-02 Exam

Topics

#PostgreSQL indexes#index types#index performance#CREATE INDEX

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full PGCES-02 Practice