ocpÌâ¿â½âÎö£º11g-1Z0-051-µÚ10Ì⣬ÍêÕûÌâ¿âÇëµã»÷ÕâÀïÁªÏµÀÏʦ×ÉѯÁ˽â

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

´ð°¸½âÎö£º

ÌáÒªÒªÇó:±¨±íÌṩ´ÙÏúÆÚ¼äÿÖܵijɱ¾

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