Coin163

首页 > 11.View the Exhibit and examine the structure of the PRODUCTS table.

11.View the Exhibit and examine the structure of the PRODUCTS table.

相关标签: oracle 1z0-051 structure

2020腾讯云10周年活动,优惠非常大!(领取2860元代金券),
地址https://cloud.tencent.com/act/cps/redirect?redirect=1040

2020阿里云最低价产品入口,含代金券(新老用户有优惠),
入口地址https://www.aliyun.com/minisite/goods

相关推荐:60.View the Exhibit and examine the structure of CUSTOMERS table.

60.View the Exhibit and examine the structure of CUSTOMERS table. Evaluate the following query: SQL>SELECT cust_id, cust_city FROM customers WHERE  cust_first_name NOT LIKE 'A_%g_%' AND cust_credit_limit BETWEEN 5000 AND 15000 AND cust_cred

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.
答案:A
解析:这道题问的是如果所有的括号去掉,输出会是什么,

相关推荐:159.View the Exhibit and examine the structure of the CUSTOMERS table.

159.View the Exhibit and examine the structure of the CUSTOMERS table. NEW_CUSTOMERS is a new table with the columns CUST_ID, CUST_NAME and CUST_CITY that have the same data types and size as the corresponding columns in the CUSTOMERS table

也是考察优先级的
prod_list_price -(prod_list_price*(25/100))+(prod_list_price -(prod_list_price*(25/100))*(15/100))+100去掉括号后
prod_list_price -prod_list_price*25/100+prod_list_price -prod_list_price*25/100*15/100+100
可以看到,其实是没有影响的,所以选择A

原文

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 afte

------分隔线----------------------------