ocp認證題：11g-1Z0-051-v9.02-010題
最新學訊：近期OCP認證正在報名中，因考試人員較多請盡快報名獲取最近考試時間，報名費用請聯(lián)系在線老師，甲骨文官方認證，報名從速！
我要咨詢ocp認證題：11g-1Z0-051-v9.02-010題 完整題庫請點擊這里聯(lián)系老師咨詢了解
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;
Answer: D
試題解析：
提要要求:報表提供促銷期間每周的成本
D,正確，符合題意。
ABC語法錯誤
sh@TEST0924> 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/7 FROM promotions
*
ERROR at line 1:
ORA-00932: inconsistent datatypes: expected NUMBER got DATE
sh@TEST0924> 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)/7 FROM promotions
*
ERROR at line 1:
ORA-00932: inconsistent datatypes: expected NUMBER got DATE
sh@TEST0924> 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/7) FROM promotions
*
ERROR at line 1:
ORA-00932: inconsistent datatypes: expected NUMBER got DATE
PostgreSQL入門到精通 100+ 個學習資料
- 陳衛(wèi)星-老師CUUG金牌講師
- 陳老師 CUUG金牌講師 精通Oracle管理、備份恢復、性能優(yōu)化 11年Ora...[詳細了解老師]
