nerdexam
PostgreSQL_CE

PGCES-02 · Question #9

The table "tbl" is defined below such that it could only store non-negative integers in the column "nn". Select the keyword that is applicable for the underlined blank. CREATE _______ natural_number…

The correct answer is E. DOMAIN. See the full explanation below for the reasoning.

Question

The table "tbl" is defined below such that it could only store non-negative integers in the column "nn". Select the keyword that is applicable for the underlined blank. CREATE _______ natural_number AS DECIMAL CHECK (VALUE >= 0); CREATE TABLE tbl(nn natural_number);

Options

  • AVIEW
  • BSCHEMA
  • CRULE
  • DTYPE
  • EDOMAIN

How the community answered

(41 responses)
  • A
    15% (6)
  • B
    2% (1)
  • C
    5% (2)
  • D
    5% (2)
  • E
    73% (30)

Community Discussion

No community discussion yet for this question.

Full PGCES-02 Practice