OCP-1Z0-051 第十題

02-12

原題：

View the Exhibit;examine the structure of the PROMOTIONS table.Each promotion has a duration of at least seven days.

Your amanager has asked you to generate a report, which provides the weekly cost for each promotion done to I 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

翻譯：

觀察PROMOTIONS表的結構。

所有的促銷活動至少持續7天。

你的領導讓你提交一份報表，該報表提供促銷期間每周的成本。

以下哪個查詢能夠得到需要的報表。