PostgreSQL Exam PGCES-02 Topic 3 Question 4 Discussion

Actual exam question for PostgreSQL's PGCES-02 exam

Question #: 4
Topic #: 3

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.

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

BINSERT INTO ftrans VALUES (2, 1, '2007-07-07');

CUPDATE fmaster SET name = 'itemAX' WHERE id = 1;

DUPDATE fmaster SET id = 100 WHERE id = 1;

EUPDATE ftrans SET id = 200 WHERE id = 1;

Show Suggested Answer

Suggested Answer: A, C

by Chau at May 07, 2022, 11:09 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

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