资讯

精准传达 • 有效沟通

从品牌网站建设到网络营销策划,从策略到执行的一站式服务

OCP-051-006

6. Examine the structure of the SHIPMENTS table:
    检查表SHIPMENTS 的结构
name Null Type
PO_ID NOT NULL NUMBER(3)
PO_DATE NOT NULL DATE
SHIPMENT_DATE NOT NULL DATE
SHIPMENT_MODE VARCHAR2(30)
SHIPMENT_COST NUMBER(8,2)

You want to generate a report that displays the PO_ID and the penalty amount to be paid if the SHIPMENT_DATE is later than one month from the PO_DTAE. The penalty is $20 per day.Evaluate the following two queries:
你想生成一个显示po_id和罚款金额的报表, 如果SHIPMENT_DATE 晚于PO_DTAE一个月,那么将会产生罚款,罚款金额为每天$20.

SQL> SELECT po_id, CASE
WHEN MONTHS_BETWEEN (shipment_date,po_date)>1 THEN
TO_CHAR((shipment_date - po_date) * 20) ELSE 'No Penalty' END PENALTY FROM shipments;

SQL>SELECT po_id, DECODE (MONTHS_BETWEEN (po_date,shipment_date)>1, TO_CHAR((shipment_date - po_date) * 20), 'No Penalty') PENALTY FROM shipments;

Which statement is true regarding the above commands?
A. Both execute successfully and give correct results.
B. Only the first query executes successfully but gives a wrong result.
C. Only the first query executes successfully and gives the correct result.
D. Only the second query executes successfully but gives a wrong result.
E. Only the second query executes successfully and gives the correct result.


标题名称:OCP-051-006
标题链接:http://cdkjz.cn/article/goiisi.html
多年建站经验

多一份参考,总有益处

联系快上网,免费获得专属《策划方案》及报价

咨询相关问题或预约面谈,可以通过以下方式与我们联系

大客户专线   成都:13518219792   座机:028-86922220