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%

Off

Get Premium PGCES-02 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Virgilio

16 days ago

I'm just going to go with option E and hope for the best. As long as it doesn't generate a syntax error, I'm happy. Who needs to understand the intricacies of table inheritance, anyway?

upvoted 0 times

...

Sherill

30 days ago

Haha, this is a classic case of 'off-by-one' error. The 'INSERT' statement is missing the column names, so option C is the right answer. Better double-check your SQL, folks!

upvoted 0 times

Laticia

13 days ago

Oops, looks like someone forgot to specify the column names in the INSERT statement.

upvoted 0 times

...

2 months ago

I think the correct answer is E.

upvoted 0 times

...