OCP-1Z0-051-V9.02-11题

发布时间:2017-5-29 8:20:55 编辑:www.fx114.net 分享查询网我要评论
本篇文章主要介绍了"OCP-1Z0-051-V9.02-11题",主要涉及到OCP-1Z0-051-V9.02-11题方面的内容,对于OCP-1Z0-051-V9.02-11题感兴趣的同学可以参考一下。

11. 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. SQL>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; What would be the outcome if all the parenthese s 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.   [email protected]> SELECT prod_name, prod_list_price -(prod_list_price*(25/100)) 2 +(prod_list_price -(prod_list_price*(25/100))*(15/100))+100 3 AS "TOTAL PRICE" 4 FROM products where rownum<6 5 order by "TOTAL PRICE"; PROD_NAME TOTAL PRICE -------------------------------------------------- ----------- Y Box 613.732875 5MP Telephoto Digital Camera 1641.23288 17" LCD w/built-in HDTV Tuner 1812.48288 Envoy 256MB - 40GB 1812.48288 Mini DV Camcorder with 3.5" Swivel LCD 1983.73288 去除括号后: [email protected]> SELECT prod_name, prod_list_price -prod_list_price*25/100 2 +prod_list_price -prod_list_price*25/100*15/100+100 3 AS "TOTAL PRICE" 4 FROM products where rownum<6 5 order by "TOTAL PRICE"; PROD_NAME TOTAL PRICE -------------------------------------------------- ----------- Y Box 613.732875 5MP Telephoto Digital Camera 1641.23288 17" LCD w/built-in HDTV Tuner 1812.48288 Envoy 256MB - 40GB 1812.48288 Mini DV Camcorder with 3.5" Swivel LCD 1983.73288 虽然计算顺序不一样,但计算结果是一样的   此题答案选:B

上一篇:linux svn
下一篇:Android学习笔记03:学习过程中碰到的一些问题及解决方法

相关文章

相关评论

本站评论功能暂时取消,后续此功能例行通知。

一、不得利用本站危害国家安全、泄露国家秘密,不得侵犯国家社会集体的和公民的合法权益,不得利用本站制作、复制和传播不法有害信息!

二、互相尊重,对自己的言论和行为负责。