PGCES-02 practice question 10 of 10
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…
Choose your answer, then check it against the explanation.
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);
Question 10 of 10
Keep practicing
Take the free PGCES-02 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other PGCES-02 practice questions
- Question 1Select a correct SQL command to change existing user "george"'s password to "foobar".
- Question 2A sequence has the following definition: CREATE SEQUENCE seq1 CACHE 10 CYCLE; Select the …
- Question 3Select two suitable statements regarding the following SQL statement: CREATE TRIGGER trig…
- Question 4Select one incorrect description regarding the following SQL statement defining a functio…
- Question 5Select one incorrect statement regarding psql.
- Question 6Select two correct statements about the command shown below. Note: $ is the command promp…
