PostgreSQL_CE
PGCES-02 · Question #135
PGCES-02 Question #135: Real Exam Question with Answer & Explanation
Sign in or unlock PGCES-02 to reveal the answer and full explanation for question #135. The question stem and answer options stay visible for context.
Question
The table "foo" is defined as follows: CREATE TABLE foo (bar TEXT); Next, four SQL statements were executed in the following order. INSERT INTO foo VALUES ('bar'); -------- (1) ALTER TABLE foo ADD COLUMN c1 TEXT; ---- (2) ALTER TABLE foo ADD UNIQUE (c1); ------- (3) ALTER TABLE foo DROP COLUMN bar; ------- (4) Select the correct statement from those below.
Options
- AAn error occurs when executing the (1) SQL statement.
- BAn error occurs when executing the (2) SQL statement.
- CAn error occurs when executing the (3) SQL statement.
- DAn error occurs when executing the (4) SQL statement.
- ENo error is generated.
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.