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.
why no row selected?
If we check column = ” OR column = NULL or column NULL then query executes successfully but displays not result.
For the prod_id 103 we have Other, we have 2000 for the min price , and we have a unit of measure! So a result is given because (PROD_UNIT_OF_MEASURE” ..or is different than null) but the result does not respect the request “and no unit of measure” (last condition is not right)!
See comments for question 115 of exam 1Z0-051. It is the same question like this one.
Actually the answer should be B i think. Because the query returns row with where emp_id is 103.
You are right !
SELECT ‘true’FROM DUAL WHERE ‘Software/Other’ LIKE ‘%Other%’;
Returns true !
So the answer is B !!!
@Amit thank you …you clear my confusion