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

Janey

5 days ago

This is a job for the SQL Ninja! *strikes a dramatic pose* Okay, let's see... The `i` column must be greater than 0, and the `j` column must be less than 0. That means (A) and (D) are the troublemakers here. Time to show off my database kung-fu skills! *cracks knuckles*

upvoted 0 times

...

Blondell

8 days ago

Alright, let's do this! Hmm, the `i` column has to be positive, and the `j` column has to be negative. So (A) and (C) are definitely going to fail. Wait, did they say two statements? Guess I better double-check my work. *scratches head* Where's my SQL cheat sheet when I need it?

upvoted 0 times

...

Yaeko

16 days ago

Ah, the joys of database design. Clearly, the table gods have blessed us with a challenge! I'm gonna go with (C) and (D) as the troublemakers here. Null values and CHECK constraints don't always play nicely, you know. But hey, at least it's not a production database, right? *laughs nervously*

upvoted 0 times

Gerardo

2 days ago

User 1: I think (C) and (D) are the culprits.

upvoted 0 times

...

2 months ago

I think statement B will generate a constraint error.

upvoted 0 times

...