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?

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.



Leave a Reply 7

Your email address will not be published. Required fields are marked *


Jason

Jason

why no row selected?

Amit

Amit

If we check column = ” OR column = NULL or column NULL then query executes successfully but displays not result.

dan

dan

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)!

Justyna

Justyna

See comments for question 115 of exam 1Z0-051. It is the same question like this one.

sivaranjini

sivaranjini

Actually the answer should be B i think. Because the query returns row with where emp_id is 103.

Bogdan

Bogdan

You are right !

SELECT ‘true’FROM DUAL WHERE ‘Software/Other’ LIKE ‘%Other%’;

Returns true !

So the answer is B !!!

lala

lala

@Amit thank you …you clear my confusion