PostgreSQL Exam PGCES-02 Topic 6 Question 62 Discussion

Actual exam question for PostgreSQL's PGCES-02 exam

Question #: 62
Topic #: 6

[All PGCES-02 Questions]

Select two incorrect descriptions regarding the following SQL statements.

CREATE TABLE cities ( name text,

population float ); CREATE

TABLE capitals ( state

char(2) ) INHERITS

(cities);

ADefines the tables called 'cities' and 'capitals'.

B'capitals' inherits 'cities'.

CSearching 'capitals' also searches rows in 'cities'.

DThe columns 'name' and 'population' are also defined in 'capitals'.

EThe second SQL statement results in an error, since the 'INHERITS' keyword is no longer available.

Show Suggested Answer

Suggested Answer: A, E

by Emiko at May 17, 2024, 05:08 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Gilbert

12 days ago

Woah, hold up. If 'capitals' inherits 'cities', does that mean the capital cities have a higher population than the regular ones? This is getting too deep for me.

upvoted 0 times

...

Jess

14 days ago

Hmm, I'm pretty sure the 'INHERITS' keyword is just a typo. They meant to write 'INVOKES', right? That's how databases work these days, right?

upvoted 0 times

...

Adell

17 days ago

Ah, I see. So 'capitals' is the Darth Vader of 'cities', inheriting all its powers and secrets. Cool, cool.

upvoted 0 times

Timothy

2 days ago

A) Defines the tables called 'cities' and 'capitals'.

upvoted 0 times

...

2 months ago

A) Defines the tables called 'cities' and 'capitals'.

upvoted 0 times

...