nerdexam
PostgreSQL_CE

PGCES-02 · Question #85

Select two correct descriptions about views.

The correct answer is B. A view is a virtual table which does not exist. C. A view is created to simplify complicated queries. See the full explanation below for the reasoning.

Question

Select two correct descriptions about views.

Options

  • AA view is created by 'DECLARE VIEW', and deleted by 'DROP VIEW'.
  • BA view is a virtual table which does not exist.
  • CA view is created to simplify complicated queries.
  • DYou can create a view with the same name as already existing tables.
  • EA view only exists while the postmaster is running, and is deleted when the postmaster stops.

How the community answered

(21 responses)
  • A
    14% (3)
  • B
    71% (15)
  • D
    10% (2)
  • E
    5% (1)

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full PGCES-02 Practice