MENU
Select one incorrect statement about schemas.
Suggested Answer: C
Get Premium PGCES-02 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
34 comments · newest first
BE
Ben
10 months ago
I thought 'DROP SCHEMA' just removes the objects inside, not the schema itself.
CA
Caitlin
11 months ago
'CREATE SCHEMA' is the way to go for new schemas!
LE
Lennie
11 months ago
Wait, can one user really own multiple schemas?
HO
Hollis
11 months ago
I agree, option C is definitely incorrect.
RO
Roxane
11 months ago
A schema is indeed a namespace for database objects.
JU
Justa
12 months ago
I believe option D is definitely correct since 'SELECT current_schema();' is a common command we practiced.
CH
Charisse
12 months ago
I’m a bit confused about option A; I thought a schema was more than just a namespace.
CL
Clorinda
12 months ago
I remember practicing a question about creating schemas, so I feel confident that option B is correct.
RE
Remedios
1 year ago
I think option C might be the incorrect one, but I'm not entirely sure if a user can own multiple schemas.
MA
Malinda
1 year ago
I'm pretty sure the answer is C. A user can definitely own multiple schemas, so that statement is incorrect.
GL
Glory
1 year ago
I'm leaning towards D being the incorrect statement. I'm not sure if 'SELECT current_schema();' is the right way to get the current schema.
HA
Hana
1 year ago
Okay, let's think this through step-by-step. A schema is a namespace, so A is correct. B and E are also correct. I think C is the incorrect statement.
RO
Rory
1 year ago
Hmm, I'm a bit unsure about this. I'll need to review my notes on schemas to make sure I understand the differences between the statements.
AU
Audry
1 year ago
I'm pretty confident about this one. I think the incorrect statement is C, since a single user can own multiple schemas.
BR
Brunilda
2 years ago
I heard the exam proctor is a real stickler for details. Better not mess this one up!
MA
Malcolm
2 years ago
Option E is the correct answer. 'DROP SCHEMA' deletes a schema, not the other options.
NA
Nada
2 years ago
Wait, we're supposed to pick the incorrect statement? I thought this was a 'select the correct answer' kind of question.
WH
Whitney
2 years ago
D) 'SELECT current_schema();' returns the current schema.
ST
Stephaine
2 years ago
C) One user cannot own multiple schemas.
BR
Brande
2 years ago
B) A new schema is created by 'CREATE SCHEMA'.
SH
Shannon
2 years ago
A) A schema is the name space for a database object.
FR
Franchesca
2 years ago
All these options look right to me. Guess I'll just pick one randomly and hope for the best.
GR
Gracia
2 years ago
I remember creating a schema once and it was a real headache. Glad I don't have to do that again!
CH
Chantell
2 years ago
But once it's done, it makes managing the database easier.
GE
Germaine
2 years ago
I agree, it can be a headache.
DO
Dorothea
2 years ago
Creating a schema can be tricky sometimes.
DE
Delfina
2 years ago
Option C is incorrect. A user can own multiple schemas.
TI
Tiffiny
2 years ago
D) 'SELECT current_schema();' returns the current schema.
DA
Daren
2 years ago
C) One user cannot own multiple schemas.
SH
Sharee
2 years ago
B) A new schema is created by 'CREATE SCHEMA'.
DE
Deonna
2 years ago
A) A schema is the name space for a database object.
JA
Jackie
2 years ago
I think the incorrect statement is E.
OR
Oren
2 years ago
I disagree, I believe the incorrect statement is A.
GL
Glory
2 years ago
I think the incorrect statement is C.