PostgreSQL PGCES-02 Exam - Topic 10 Question 17 Discussion

Actual exam question for PostgreSQL's PGCES-02 exam

Question #: 17
Topic #: 10

[All PGCES-02 Questions]

Select two incorrect statements concerning the BOOLEAN type in PostgreSQL.

ABOOLEAN is an alias of the INTEGER type in PostgreSQL.

BBOOLEAN only takes either NULL, TRUE, or FALSE.

CYou can use the characters 't' or 'f' as a value for the BOOLEAN type.

DYou can use the TRUE or FALSE keywords as a value for the BOOLEAN type.

EIf the INTEGER value of '0' is inserted into a BOOLEAN column, it will be treated as FALSE.

Show Suggested Answer

Suggested Answer: A, E

by Dick at May 03, 2022, 04:54 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Lucia

4 months ago

I thought BOOLEAN could only be TRUE or FALSE, but I guess not!

upvoted 0 times

...

Alonzo

4 months ago

B is also incorrect, it can take NULL too.

upvoted 0 times

...

Vincent

4 months ago

Wait, can you really use 't' and 'f'? That's surprising!

upvoted 0 times

...

Paz

4 months ago

Totally agree, A is wrong!

upvoted 0 times

...

Lucy

4 months ago

BOOLEAN is definitely not an alias for INTEGER.

upvoted 0 times

...

Laurena

5 months ago

I’m pretty confident that D is correct since TRUE and FALSE are standard keywords, but I’m unsure about E and how INTEGER values interact with BOOLEAN.

upvoted 0 times

...

Bronwyn

5 months ago

I remember practicing a question where BOOLEAN could only be TRUE or FALSE, so I think B might be correct.

upvoted 0 times

...

Tijuana

5 months ago

I think option A is definitely incorrect because BOOLEAN is not an alias for INTEGER, but I'm not completely sure about the second one.

upvoted 0 times

...

Clement

5 months ago

I feel like I've seen something about using 't' and 'f' for BOOLEAN values, so maybe C is wrong?

upvoted 0 times

...

Alfreda

5 months ago

Hmm, I'm not too familiar with the Avaya Aura Media Server, so I'll need to think this through carefully. Let me re-read the question and options to make sure I understand what it's asking.

upvoted 0 times

...

Luis

5 months ago

This looks like a straightforward NPSP configuration question. I'll review the options carefully and think through the memberships feature.

upvoted 0 times

...