Chinaunix首页 | 论坛 | 博客
  • 博客访问: 1065879
  • 博文数量: 239
  • 博客积分: 10
  • 博客等级: 民兵
  • 技术积分: 3618
  • 用 户 组: 普通用户
  • 注册时间: 2012-11-12 13:17
文章分类

全部博文(239)

文章存档

2021年(1)

2016年(1)

2015年(30)

2014年(91)

2013年(116)

分类: Oracle

2015-03-20 01:25:41

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.
Answer: B
此题的意思是去除括号后,答案是否一样,其实这是一道数学题,去除括号后,其实一样。
阅读(1069) | 评论(0) | 转发(0) |
0

上一篇:1Z0-051-10题

下一篇:1Z0-051-12题

给主人留下些什么吧!~~