Re: plz help with a question(corrected an error)

In article <8re6jl$vne$1_at_nnrp1.deja.com>,   volk333_at_my-deja.com wrote:
> 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.
>

Answer b is correct. There are 5 conditions provided for the problem (item #3 has two conditions) and 2 of these 5 are met with the query listed: the price times 25% equals $4 and the manufacturer number equals 25001. Since two of the criteria are met answer e cannot be correct.

--
David Fitzjarrell
Oracle Certified DBA


Sent via Deja.com http://www.deja.com/
Before you buy.