View the Exhibit and examine the structure of the products table.
All products have a list price.
You issue the following command to display the total price of each product after a discount of 25%
and a tax of 15% are applied on it. Freight charges of $100 have to be applied to all the products.
What would be the outcome if all the parentheses are removed from the above statement?
A.
It produces a syntax error.
B.
The result remains unchanged.
C.
The total price value would be lower than the correct value.
D.
The total price value would be higher than the correct value.
Explanation:
I think the correct answer is D.
To get the the answer B the command will be ‘select prod_name, prod_list_price – (prod_list_price*(25/100)) + (prod_list_price – (prod_list_price*(25/100)))*(15/100)+100
as “Total Price”
from products;
the question is incorrectly written. Yes, the fact is that “The result remains unchanged”. However, using 100 as the list price, the question requests adding 15% tax to the discounted price (100 – 25 = 75) or 11.25 should be the tax. So all total would be 100 – 25 + 11.25 + 100 = 186.25.
The question is poorly written. As written the tax is calculated against (100 * .25 = 25). They are taxing the discount itself of 25, not the discounted price of 75.
Answer B is correct – under the given circumstances… 😉
That could be the finish of this report. Right here you will find some web sites that we consider youll appreciate, just click the links.
we came across a cool internet site that you may well get pleasure from. Take a search if you want
Here is an excellent Blog You might Locate Exciting that we encourage you to visit.
the time to study or visit the content material or sites we have linked to below the
that will be the end of this report. Here you will find some web pages that we believe you will appreciate, just click the hyperlinks over
B. 100%
Answer B is fake news. If you calculate that through you will easily see that the calculation without paranthesis is a lot larger. So the correct answer is easily D.