BlackFriday 2024! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

PostgreSQL Exam PGCES-02 Topic 3 Question 4 Discussion

Actual exam question for PostgreSQL's PGCES-02 exam
Question #: 4
Topic #: 3
[All PGCES-02 Questions]

SQL statements were executed in the following order:

CREATE TABLE fmaster

(id INTEGER PRIMARY KEY, name TEXT);

CREATE TABLE ftrans

(id INTEGER REFERENCES fmaster (id), stat INTEGER, date DATE);

INSERT INTO fmaster VALUES (1, 'itemA');

INSERT INTO ftrans VALUES (1, 1, CURRENT_DATE);

Select two SQL statements that will generate an error when executed next.

Show Suggested Answer Hide Answer
Suggested Answer: A, C

Contribute your Thoughts:

Currently there are no comments in this discussion, be the first to comment!


Save Cancel