nerdexam
PostgreSQL_CE

PGCES-02 · Question #53

Select two incorrect statements concerning the BOOLEAN type in PostgreSQL.

The correct answer is A. BOOLEAN is an alias of the INTEGER type inPostgreSQL. E. If the INTEGER value of '0' is inserted into a BOOLEAN column, it will be treated as FALSE. See the full explanation below for the reasoning.

Question

Select two incorrect statements concerning the BOOLEAN type in PostgreSQL.

Options

  • ABOOLEAN is an alias of the INTEGER type inPostgreSQL.
  • BBOOLEAN only takeseither NULL, TRUE, or FALSE.
  • CYou can use thecharacters 't' or 'f' as a value for the BOOLEAN type.
  • DYou can use the TRUE or FALSE keywords as a value for the BOOLEAN type.
  • EIf the INTEGER value of '0' is inserted into a BOOLEAN column, it will be treated as FALSE.

How the community answered

(39 responses)
  • A
    77% (30)
  • B
    5% (2)
  • C
    13% (5)
  • D
    5% (2)

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full PGCES-02 Practice