PostgreSQL Exam PGCES-02 Topic 4 Question 54 Discussion

Actual exam question for PostgreSQL's PGCES-02 exam

Question #: 54
Topic #: 4

You want to set a constraint so that the "item_id" in the "sales" table will always have a value that already exists as "id" in the "item_master" table. Select the correct SQL statement to fill in the underlined blank of the "sales" table. Definitions: CREATE TABLE item_master ( id INTEGER PRIMARY KEY, name TEXT ); CREATE TABLE sales ( sales_id INTEGER, item_id INTEGER, num INTEGER, );

AFOREIGN KEY (id) REFERENCES item_master (item_id)

BFOREIGN KEY (item_id) REFERENCES item_master (id)

CREFERENCES item_master (item_id)

DREFERENCES item_master (id)

EREFERENCES item_master (id) TO item_id

Show Suggested Answer

Suggested Answer: A, E

by Marge at Jan 23, 2024, 05:09 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Millie

12 days ago

I bet the correct answer is 'ALTER TABLE sales ADD CONSTRAINT item_id_fkey FOREIGN KEY (item_id) REFERENCES item_master(id)'. I mean, who doesn't love a little extra SQL syntax to spice things up?

upvoted 0 times

...

Ahmad

16 days ago

I wonder if the exam writer is a secret comedian. 'FOREIGN KEY (id) REFERENCES item_master (item_id)' - that's like trying to reference the moon by its serial number!

upvoted 0 times

...

Darell

21 days ago

Ah, the joys of database design! I'm going to have to think this one through carefully. Maybe I'll just ask the database gods for a little guidance.

upvoted 0 times

Trevor

1 days ago

I think the correct SQL statement is B) FOREIGN KEY (item_id) REFERENCES item_master (id)

upvoted 0 times

...

Tonette

25 days ago

I'll go with D. It just makes sense to reference the primary key of the 'item_master' table, right? That way, we can ensure the integrity of the data.

upvoted 0 times

...

Sharee

27 days ago

Hmm, I'm not sure. It's been a while since I've dealt with SQL constraints. Maybe I should brush up on my database fundamentals before taking this exam.

upvoted 0 times

Rory

18 days ago

User1: I think the correct SQL statement is B) FOREIGN KEY (item_id) REFERENCES item_master (id)

upvoted 0 times

...

2 months ago

I think the correct answer is B) FOREIGN KEY (item_id) REFERENCES item_master (id). It makes sense to reference the 'id' column in 'item_master' table.

upvoted 0 times

...