PostgreSQL_CE
PGCES-02 · Question #93
PGCES-02 Question #93: Real Exam Question with Answer & Explanation
Sign in or unlock PGCES-02 to reveal the answer and full explanation for question #93. The question stem and answer options stay visible for context.
Question
Four SQL statements were executed in the following order. CREATE TABLE foo (bar INT); ALTER TABLE foo ALTER bar TYPE BIGINT; ALTER TABLE foo ADD baz VARCHAR(5); ALTER TABLE foo DROP bar; Select two SQL statements that generate an error when executed.
Options
- AINSERT INTOfoo VALUES ('12345');
- BINSERT INTOfoo VALUES ('5000000000');
- CINSERT INTOfoo VALUES ('ABC');
- DINSERT INTOfoo VALUES (2000000000);
- EINSERT INTOfoo VALUES (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.