PostgreSQL_CE
PGCES-02 · Question #141
PGCES-02 Question #141: Real Exam Question with Answer & Explanation
Sign in or unlock PGCES-02 to reveal the answer and full explanation for question #141. 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 the two SQL statements that will generate an error when executed next.
Options
- ADROP TABLEftrans;
- BINSERT INTOfmaster VALUES (1, 'itemB');
- CDELETE FROMfmaster;
- DUPDATEfmaster SET name = NULL;
- EINSERT INTOftrans VALUES (1, 2, NULL);
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.