Select two incorrect statements concerning the BOOLEAN type in PostgreSQL.
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
11 comments · newest first
LU
Lucia
11 months ago
I thought BOOLEAN could only be TRUE or FALSE, but I guess not!
AL
Alonzo
11 months ago
B is also incorrect, it can take NULL too.
VI
Vincent
12 months ago
Wait, can you really use 't' and 'f'? That's surprising!
PA
Paz
12 months ago
Totally agree, A is wrong!
LU
Lucy
12 months ago
BOOLEAN is definitely not an alias for INTEGER.
LA
Laurena
1 year 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.
BR
Bronwyn
1 year ago
I remember practicing a question where BOOLEAN could only be TRUE or FALSE, so I think B might be correct.
TI
Tijuana
1 year 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.
CL
Clement
1 year ago
I feel like I've seen something about using 't' and 'f' for BOOLEAN values, so maybe C is wrong?
AL
Alfreda
1 year 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.
LU
Luis
1 year ago
This looks like a straightforward NPSP configuration question. I'll review the options carefully and think through the memberships feature.