PostgreSQL Exam PGCES-02 Topic 11 Question 58 Discussion

Actual exam question for PostgreSQL's PGCES-02 exam

Question #: 58
Topic #: 11

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 ) );

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);

Show Suggested Answer

Suggested Answer: A, D

by Yolando at Apr 11, 2024, 03:25 AM

Limited Time Offer

25%

Off

Get Premium PGCES-02 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Berry

2 days ago

Well, look at that, an opportunity to show off my SQL prowess! Let's see, the question is which statements will generate a constraint error. Hmmm, I'm thinking (A) and (C) are the ones that will fail. Gotta love those pesky CHECK constraints!

upvoted 0 times

...