Oracle.1Z0-051.175q(7)

OCP 11g 051题库

A. SELECT promo_name, promo_cost/promo_end_date-promo_begin_date/7 FROM promotions;

B. SELECT promo_name,(promo_cost/promo_end_date-promo_begin_date)/7 FROM promotions;

C. SELECT promo_name, promo_cost/(promo_end_date-promo_begin_date/7) FROM promotions;

D. SELECT promo_name, promo_cost/((promo_end_date-promo_begin_date)/7) FROM promotions;

Answer: D

QUESTION 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

QUESTION 12

You need to produce a report where each customer's credit limit has been incremented by $1000. In the

output, t he customer's last name should have the heading Name and the incremented credit limit should

搜索“diyifanwen.net”或“第一范文网”即可找到本站免费阅读全部范文。收藏本站方便下次阅读，第一范文网，提供最新小学教育Oracle.1Z0-051.175q(7)全文阅读和word下载服务。