View the Exhibit and examine the data in the PRODUCTS table. 

You must display product names from the PRODUCTS table that belong to the `Software/other` category with minimum prices as either $2000 or $4000 and with no unit of measure. You issue this query: 

Which statement is true? 

Answer options:

A. It executes successfully but returns no result.
B. It executes successfully and returns the required result.
C. It generates an error because the condition specified for PROD_UNIT_OF_MEASURE is not valid.
D. It generates an error because the condition specified for the PROD_CATEGORY column is not valid.

A