plz help with a question(corrected an error)

From: <volk333_at_my-deja.com>
Date: Wed, 04 Oct 2000 03:02:15 GMT
Message-ID: <8re6jl$vne$1@nnrp1.deja.com>

sorry ,there was an error in my question. i am posting it again.

 you want to display item prices from inventory with these desired results:

1.the price of each item is increased by 25 persent.
2.the original price must be over $25.
3.the item manufacturer number must be 25001 or 25050.
4.the original price when multiplied by 25% equals $4.

 you query the database with this SQL statement:

SELECT price

FROM      inventory
WHERE     price*.25=4.00
AND       manufacturer_id='25001'
OR        manufacturer_id='25050'   --here i made an error in number!
OR        price>25.00;

Which result(s) is true?

a.one of the desired results.
b.two of the desired results.
c.three of the desired results.
d.four of the desired results.
e.none of the desired results.

(explanation)
right answer is b.
only two of the desired results are achieved when the script is executed. Desired result #3 which specifies that the item manufacturer number be 25001 or 25050, and desired result #4 which specifies that the price, when multiplied by 25%, equal $4. The statement does not specify that the price of each item be increased by 25 percent or that the price must be over $25 (since the OR logical operator is used instead of the AND operator).

.............................................................

this answer does not look right to me. what do you think? i think the right answer is e .

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Oct 03 2000 - 22:02:15 CDT