PostgreSQL_CE

PGCES-02 · Question #52

Select one incorrect statement about schemas.

The correct answer is C. One user cannot own multiple schemas. See the full explanation below for the reasoning.

Question

Select one incorrect statement about schemas.

Options

AA schema is the name space for a database object.
BA new schema is created by 'CREATE SCHEMA'.
COne user cannot own multiple schemas.
D'SELECTcurrent_schema();' returns the current schema.
E'DROP SCHEMA' deletes a schema.

How the community answered

(27 responses)

A
7% (2)
C
74% (20)
D
15% (4)
E
4% (1)

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion

Full PGCES-02 Practice