PostgreSQL_CE
PGCES-02 · Question #94
PGCES-02 Question #94: Real Exam Question with Answer & Explanation
Sign in or unlock PGCES-02 to reveal the answer and full explanation for question #94. The question stem and answer options stay visible for context.
Question
A table named "sample" is defined as below. Select two statements which will generate a constraint error. CREATE TABLE sample ( i INTEGER PRIMARY KEY, j INTEGER, CHECK ( i > 0 AND j < 0 ) );
Options
- AINSERT INTO sample VALUES (1, 0);
- BINSERT INTO sample VALUES (2, -2);
- CINSERT INTO sample VALUES (3, NULL);
- DINSERT INTO sample VALUES (NULL, -4);
- EINSERT INTO sample VALUES (5, -5);
Unlock PGCES-02 to see the answer
You've previewed enough free PGCES-02 questions. Unlock PGCES-02 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.