Which statement is true regarding the above query?

View the Exhibit and examine the data in the PRODUCTS table. You need to display
product names from the PRODUCTS table that belong to the ‘Software/Other1 category
with minimum prices as either $2000 or $4000 and no unit of measure. You issue thej
following query: Which statement is true regarding the above query?

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.