Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

PostgreSQL PGCES-02 Exam - Topic 4 Question 95 Discussion

Actual exam question for PostgreSQL's PGCES-02 exam
Question #: 95
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;

Show Suggested Answer Hide Answer
Suggested Answer: E

by Larae at Jan 28, 2026, 06:04 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Keith
24 hours ago
Haha, this question is like a game of SQL Jeopardy! I'm going to go with the empty result set just to be safe.
upvoted 0 times
...
Vilma
6 days ago
I think the question is trying to trick us. The data should be in the log table since it's being inserted into the child table log_01.
upvoted 0 times
...
Ailene
11 days ago
Hmm, I'm not sure about that. Shouldn't the data be visible in the parent table log as well?
upvoted 0 times
...
Frederica
16 days ago
The correct result is an empty result set, as the data is inserted into the child table log_01 and not the parent table log.
upvoted 0 times
...
Johana
22 days ago
I believe the log table won't show the inserted row since it only exists in log_01. I hope I remember this correctly!
upvoted 0 times
...
Aileen
27 days ago
This reminds me of a practice question where we had to deal with table inheritance. I feel like the output will be empty too, but I can't recall the exact details.
upvoted 0 times
...
Lenita
2 months ago
I'm not entirely sure, but I remember something about inheritance in SQL. The data might not show up in the parent table since the insert was done in the child table.
upvoted 0 times
...
Chanel
2 months ago
I think the SELECT statement will return an empty result because we are selecting from the parent table, and we haven't inserted anything into it.
upvoted 0 times
...
Casey
2 months ago
Alright, let me walk through this step-by-step. We create the 'log' table, then create 'log_01' as a child table that inherits from 'log'. When we insert into 'log_01', that data gets propagated up to the parent 'log' table. So the SELECT should return the row we inserted. I think I've got the right approach here.
upvoted 0 times
...
Davida
2 months ago
I think I've got this. Since 'log_01' inherits from 'log', any rows inserted into 'log_01' will also be visible in the 'log' table. So the SELECT * FROM log; should return the row we inserted into 'log_01'. Feeling pretty confident about this one.
upvoted 0 times
...
Hester
2 months ago
I'm a bit confused on the table inheritance part. Does that mean the data in 'log_01' will automatically show up in the 'log' table? I'll need to review how that works before answering this.
upvoted 0 times
...
Evangelina
3 months ago
Okay, let's see here. We're creating a table 'log' and then creating a child table 'log_01' that inherits from it. Then we insert a row into 'log_01'. The question is asking what the SELECT * FROM log; will return. Interesting, let me work this through.
upvoted 0 times
...
Marcos
3 months ago
Hmm, this looks like a question on inheritance and polymorphism in SQL. I'll need to think through how the table inheritance works and how the data gets propagated.
upvoted 0 times
...

Save Cancel