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

Contribute your Thoughts:

Submit Cancel

17 days ago

C) Searching 'capitals' also searches rows in 'cities'. That's not true, they are separate tables.

upvoted 0 times

...

18 days ago

B) 'capitals' inherits 'cities'. That's correct.

upvoted 0 times

...

24 days ago

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

upvoted 0 times

...