Asked by Dekia Mitchell on Jul 05, 2024
Verified
To find employee records that do not contain an entry in the Email field, use the _____ criterion in the Email field.
A) Is Not Null
B) Is Null
C) Find Unmatched
D) Is Blank
Is Null
A condition or operator in programming and database management that checks for the absence of a value.
Email Field
A designated input area within a form or database for capturing a user's email address.
- Develop skills in managing null and zero-length field values within queries.
Verified Answer
ZK
Zybrea KnightJul 12, 2024
Final Answer :
B
Explanation :
The correct choice is B, "Is Null". This criterion will return all employee records where the Email field is empty or has no value entered. "Is Not Null" would return all employee records where the Email field contains a value, which is not what we want. "Find Unmatched" is used to compare two tables and find records that do not match, so it is not applicable in this scenario. "Is Blank" is not a valid criterion in most database systems.
Learning Objectives
- Develop skills in managing null and zero-length field values within queries.