What happens when you run a query with the Is Null criterion in the Product Type field?
A) The results include only records with a correct Product Type value.
B) The query deletes the values in the Product Type field.
C) The query moves records with no Product Type value to a history table.
D) The results include only records with no Product Type value.

Question

Quizplus · Accepted Answer

When you run a query with the Is Null criterion in the Product Type field, the results will include only records with no Product Type value. This is because the Is Null criterion is asking for records where the value in the Product Type field is null (i.e. has no value). Therefore, the query will only return records where the Product Type field is empty.

What Happens When You Run a Query with the Is