PostgreSQL_CE
PGCES-02 · Question #137
PGCES-02 Question #137: Real Exam Question with Answer & Explanation
Sign in or unlock PGCES-02 to reveal the answer and full explanation for question #137. The question stem and answer options stay visible for context.
Question
PostgreSQL CE PGCES-02 Exam SQL statements were executed in the following order. CREATE TABLE book ( id VARCHAR(21), title TEXT NOT NULL, price INT, UNIQUE (id), CHECK (price > 0) ); INSERT INTO book VALUES ('4-12345-678-9', 'SQL book', 2300); --(1) INSERT INTO book (title, price) VALUES ('PostgreSQL', 3000); --(2) UPDATE book SET id = '4-12345-678-9' WHERE id IS NULL; --(3) DELETE FROM book WHERE price < 0; --(4) While executing, select the first location that generates an error.
Options
- A(1)
- B(2)
- C(3)
- D(4)
- ENo error is generated.
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.