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

Jose

13 days ago

Ooh, a tricky one! Okay, let's think this through. The table definition says the `i` column must be greater than 0 and the `j` column must be less than 0. So (B) and (E) should be good, but (A), (C), and (D) are gonna trigger that constraint error for sure. Time to put on my SQL thinking cap!

upvoted 0 times

...

Berry

16 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

...