What criterion would you use in the LastName field to find records that do not contain a last name?
A) Is Null
B) "Null"
C) Is Not Null
D) No LastName

Question

Quizplus · Accepted Answer

The criterion "Is Null" is the best choice as it searches for records where the LastName field is blank or contains no value. "Null" is not a valid keyword in SQL and would result in a syntax error. "Is Not Null" would return all records that have a value in the LastName field, which is not what is being searched for. "No LastName" is not a valid SQL keyword and would also result in a syntax error.

What Criterion Would You Use in the LastName Field to Find