MENU
Select three SQL statements which return NULL.
Suggested Answer: A, B, D
Get Premium PGCES-02 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
14 comments · newest first
PE
Peggy
11 months ago
E is just a string, not NULL.
GL
Glendora
11 months ago
I thought NULL != NULL would return something else?
MI
Misty
12 months ago
D definitely returns NULL!
CA
Casie
12 months ago
C returns TRUE, not NULL.
AL
Alex
12 months ago
A and B will return NULL.
GL
Glendora
1 year ago
I practiced a similar question, and I think SELECT NULL will return NULL, but I need to double-check the logic on the others.
KA
Kanisha
1 year ago
SELECT NULL != NULL seems tricky; I feel like it should return NULL too, but I can't recall if that's right.
IR
Irene
1 year ago
I remember that SELECT NULL IS NULL should definitely return true, so it might not be one of the answers we need.
EM
Emmanuel
1 year ago
I think SELECT 0 = NULL will return NULL, but I'm not entirely sure about the others.
MA
Maxima
1 year ago
I think the correct answer is B - enter the receipt as an unidentified receipt. That seems like the most appropriate option when you don't have enough information to identify the customer or invoice.
VI
Vinnie
1 year ago
Hmm, I'm a bit unsure about this one. I know testing is important, but I'm not sure if it's considered part of the requirements specification phase specifically. I'll have to think this through carefully.
MI
Mitsue
1 year ago
I'm a little confused by this question. The options don't seem to fully capture the essence of company policies. I'll have to review my notes and see if I can figure out the best answer.
DA
Darnell
1 year ago
Okay, let's see. The options mention bracket, desktop, and wall installation, as well as "Flip." I'm not sure what "Flip" means in this context, so I'll focus on the more common installation methods.
AL
Alease
1 year ago
Okay, I think I see what's going on. The issue is likely with trying to push elements into a queue that's constructed from a vector. I'll need to double-check the requirements for the queue container.