OCP 1Z0 051 10

来源：互联网发布：成都工业学院软件编辑：程序博客网时间：2024/04/29 17:53

10. View the Exhibit; e xamine the structure of the PROMOTIONS table.
Each promotion has a duration of at least seven days .
Your manager has asked you to generate a report, which provides the weekly cost for each promotion
done to l date.
Which query would achieve the required result?

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;
这几个语句严格来说一个都不对。

SELECT promo_name,       promo_cost,       promo_end_date,       promo_begin_date,       promo_cost / promo_end_date - promo_begin_date / 7  FROM sh.promotions WHERE rownum <= 3ORA-00932: 数据类型不一致: 应为 NUMBER, 但却获得 DATESELECT promo_name,       promo_cost,       promo_end_date,       promo_begin_date,       (promo_cost / promo_end_date - promo_begin_date) / 7  FROM sh.promotions WHERE rownum <= 3ORA-00932: 数据类型不一致: 应为 NUMBER, 但却获得 DATESELECT promo_name,       promo_cost,       promo_end_date,       promo_begin_date,       promo_cost / (promo_end_date - promo_begin_date / 7)  FROM sh.promotions WHERE rownum <= 3ORA-00932: 数据类型不一致: 应为 NUMBER, 但却获得 DATESQL> SELECT promo_name,  2         promo_cost,  3         promo_end_date,  4         promo_begin_date,  5         (promo_end_date - promo_begin_date)  6    FROM sh.promotions  7   WHERE rownum <= 3;PROMO_NAME                       PROMO_COST PROMO_END_DATE PROMO_BEGIN_DATE (PROMO_END_DATE-PROMO_BEGIN_DA------------------------------ ------------ -------------- ---------------- ------------------------------NO PROMOTION #                         0.00 9999-1-1       9999-1-1                                      0newspaper promotion #16-108          200.00 2001-1-23      2000-12-23                                   31post promotion #20-232               300.00 1998-11-25     1998-9-25                                    61Executed in 0.015 secondsSELECT promo_name,       promo_cost,       promo_end_date,       promo_begin_date,       promo_cost / ((promo_end_date - promo_begin_date) / 7)  FROM sh.promotions WHERE rownum <= 3ORA-01476: 除数为 0

可以看到前三个括号用法错了。逻辑性错误。而第四个如果起止时间一样，会报ORA-01476的错。
单从括号的用法上来说。该语句选D

Answer: D

0 0