PostgreSQL_CE
PGCES-02 · Question #93
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…
The correct answer is B. INSERT INTOfoo VALUES ('5000000000'); D. INSERT INTOfoo VALUES (2000000000). See the full explanation below for the reasoning.
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);
How the community answered
(39 responses)- A8% (3)
- B77% (30)
- C13% (5)
- E3% (1)
Community Discussion
No community discussion yet for this question.