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/other’ category with
minimum prices as either S2000 or S4000 and no unit of measure.
You issue the 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.
It should catch 103 but it is not the required result.
Found this one kinda interesting.
Looks like = ” or ” will always return nothing
and inserting ” will instead insert NULL.
As such = ” or ” should always be replaced with IS NULL or IS NOT NULL I guess.
oi … editor ate my greater/less than character