PostgreSQL Exam PGCES-02 Topic 1 Question 77 Discussion

Actual exam question for PostgreSQL's PGCES-02 exam

Question #: 77
Topic #: 1

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.

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.

Show Suggested Answer

Suggested Answer: E

by Tamesha at Nov 16, 2024, 12:14 AM

Limited Time Offer

25%

21 days ago

I think the answer is E. No error is generated. The table has been modified successfully, and the data remains intact.

upvoted 0 times

6 days ago

I think the answer is E. No error is generated.

upvoted 0 times

...

23 days ago

I think an error occurs when executing the (3) SQL statement.

upvoted 0 times

...