PostgreSQL Exam PGCES-02 Topic 4 Question 40 Discussion

Actual exam question for PostgreSQL's PGCES-02 exam

Question #: 40
Topic #: 4

[All PGCES-02 Questions]

Select the correct result generated by execution of the following SQL statements:

CREATE TABLE log (id int, message TEXT, logtime TIMESTAMP); CREATE

TABLE log_01 () INHERITS (log);

INSERT INTO log_01 VALUES (1, 'error', CURRENT_TIMESTAMP);

SELECT * FROM log;

AFirst 'CREATE TABLE' generates a syntax error.

BSecond 'CREATE TABLE' generates a syntax error.

C'INSERT' statement generates an error stating that the number of columns and values do not match'.

D'SELECT' statement returns 0 rows, and exits successfully.

E'SELECT' statement returns 1 row, and exits successfully.

Show Suggested Answer

Suggested Answer: A, D

by Izetta at Feb 25, 2023, 08:14 PM

Limited Time Offer

25%

16 days ago

I think the correct answer is E.

upvoted 0 times

...