PostgreSQL_CE
PGCES-02 · Question #87
PGCES-02 Question #87: Real Exam Question with Answer & Explanation
Sign in or unlock PGCES-02 to reveal the answer and full explanation for question #87. The question stem and answer options stay visible for context.
Question
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.
Options
- AINSERT INTOftrans VALUES (1, 1, CURRENT_DATE);
- BINSERT INTOftrans VALUES (2, 1, '2007-07-07');
- CUPDATEfmaster SET name = 'itemAX' WHERE id = 1;
- DUPDATEfmaster SET id = 100 WHERE id = 1;
- EUPDATEftrans SET id = 200 WHERE id = 1;
Unlock PGCES-02 to see the answer
You've previewed enough free PGCES-02 questions. Unlock PGCES-02 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.