PostgreSQL Exam PGCES-02 Topic 9 Question 25 Discussion

Actual exam question for PostgreSQL's PGCES-02 exam

Question #: 25
Topic #: 9

A table is defined as below. Select the most suitable description about the foreign key constraint. CREATE TABLE master (id INTEGER PRIMARY KEY, name TEXT); CREATE TABLE record (id INTEGER REFERENCES master (id), count INTEGER);

AIf any row exists in the 'record' table, no change can be made to the 'master' table.

BIf the 'record' table contains a row with an 'id', no change can be made at all to the corresponding 'id' row in the 'master' table.

CIf the 'record' table contains a row with an 'id', the corresponding 'id' row in the 'master' table cannot be deleted.

DThe 'record' table cannot have duplicate 'id's.

EThese SQL statements are invalid; no constraints are created.

Show Suggested Answer

Suggested Answer: A

by Veronika at May 07, 2022, 02:41 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Leonida

3 days ago

I disagree, I believe the answer is A. The foreign key constraint prevents any changes to the master table if a row exists in the record table.

upvoted 0 times

...

Gilbert

4 days ago

I think the answer is C. The foreign key constraint ensures that the corresponding row in the master table cannot be deleted.

upvoted 0 times

...