MENU
Select two incorrect descriptions regarding the following SQL statements.
CREATE TABLE cities ( name text,
population float ); CREATE
TABLE capitals ( state
char(2) ) INHERITS
(cities);
Suggested Answer: A, E
Get Premium PGCES-02 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
35 comments · newest first
MA
Maricela
10 months ago
D is misleading, 'capitals' doesn't redefine those columns.
AI
Aimee
11 months ago
B and C are correct descriptions.
CA
Carey
11 months ago
Wait, is the INHERITS keyword really gone? That sounds off.
LA
Lavera
11 months ago
Totally agree, E is definitely wrong!
RE
Rebbecca
11 months ago
A and E are incorrect.
MO
Mohammad
12 months ago
I feel like option A is correct, but I'm a bit confused about whether option B is also incorrect or not.
SO
Sonia
12 months ago
I remember practicing a question similar to this, and I think option C is also incorrect because searching 'capitals' should include 'cities' data.
SH
Sherell
12 months ago
I'm not sure about option D; it seems like 'capitals' wouldn't have its own 'name' and 'population' columns since it inherits from 'cities'.
LA
Latosha
1 year ago
I think option E is definitely incorrect because the INHERITS keyword is still valid in PostgreSQL.
JE
Jerry
1 year ago
The INHERITS keyword is tricky. I'll need to make sure I understand how it affects the relationship between the 'cities' and 'capitals' tables.
EL
Elfriede
1 year ago
I'm not sure about the correct answers here. I'll need to carefully read through the options and think about the SQL statements.
WE
Weldon
1 year ago
Okay, let me think this through step-by-step. The key is understanding how table inheritance works in SQL.
NA
Nan
1 year ago
This looks like a pretty straightforward SQL question. I'm confident I can handle this.
GE
Geraldine
1 year ago
Hmm, I'm a bit confused about the INHERITS keyword. I'll need to review that in my notes before answering.
MA
Margot
1 year ago
This seems like a straightforward question about the default views created when starting a new level. I'll carefully review the options and select the one that best matches the information provided.
PA
Paola
1 year ago
Hmm, I'm a bit unsure about this one. Do we need to install the Root CA and intermediate CA as well? Or is that a separate step?
JE
Jeannetta
1 year ago
I remember us practicing similar questions, and I keep mixing up definitions. I'm a bit confused between options A and D.
AN
Angelyn
1 year ago
Adding a plugin to the Jenkins pipeline to block releases when out of SLO seems like a good technical solution, but it might be too heavy-handed. I'd want to understand the tradeoffs there.
GI
Gilbert
1 year 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.
JE
Jess
1 year 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?
AD
Adell
1 year ago
Ah, I see. So 'capitals' is the Darth Vader of 'cities', inheriting all its powers and secrets. Cool, cool.
KE
Kenneth
1 year ago
E) The second SQL statement results in an error, since the 'INHERITS' keyword is no longer available.
KE
Kenda
1 year ago
C) Searching \'capitals\' also searches rows in \'cities\'.
LA
Lawrence
1 year ago
C) Searching 'capitals' also searches rows in 'cities'.
KE
Kent
1 year ago
B) \'capitals\' inherits \'cities\'.
HA
Han
1 year ago
B) 'capitals' inherits 'cities'.
CL
Claribel
1 year ago
A) Defines the tables called \'cities\' and \'capitals\'.
TI
Timothy
1 year ago
A) Defines the tables called 'cities' and 'capitals'.
DO
Dorothy
1 year ago
Wait, 'INHERITS'? Isn't that something like a superpower I get when I beat the final boss of this certification exam?
NA
Nadine
1 year ago
Exactly, it's a way to reuse the structure of an existing table in a new one.
BL
Blondell
1 year ago
So it's like creating a new table based on an existing one, with all the same columns.
CA
Carry
1 year ago
No, 'INHERITS' in SQL is used to create a table that inherits all columns of another table.
ME
Meghann
2 years ago
C) Searching 'capitals' also searches rows in 'cities'. That's not true, they are separate tables.
AS
Ashley
2 years ago
B) 'capitals' inherits 'cities'. That's correct.
ME
Meghann
2 years ago
A) Defines the tables called 'cities' and 'capitals'.