91超碰碰碰碰久久久久久综合_超碰av人澡人澡人澡人澡人掠_国产黄大片在线观看画质优化_txt小说免费全本

溫馨提示×

溫馨提示×

您好,登錄后才能下訂單哦!

密碼登錄×
登錄注冊×
其他方式登錄
點擊 登錄注冊 即表示同意《億速云用戶服務條款》

OCP-051-006

發布時間:2020-08-09 14:06:42 來源:ITPUB博客 閱讀:125 作者:fwinmachao 欄目:關系型數據庫
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.

向AI問一下細節

免責聲明:本站發布的內容(圖片、視頻和文字)以原創、轉載和分享為主,文章觀點不代表本網站立場,如果涉及侵權請聯系站長郵箱:is@yisu.com進行舉報,并提供相關證據,一經查實,將立刻刪除涉嫌侵權內容。

AI

南开区| 资中县| 通州市| 赤峰市| 高安市| 麻城市| 莱州市| 洛南县| 五大连池市| 阜城县| 深州市| 磴口县| 普兰县| 富阳市| 南丹县| 五河县| 城固县| 土默特左旗| 渭源县| 山西省| 贵阳市| 始兴县| 娱乐| 达拉特旗| 安远县| 农安县| 五寨县| 长阳| 澄城县| 习水县| 溆浦县| 余姚市| 桐乡市| 疏勒县| 丰都县| 伊金霍洛旗| 莱西市| 岫岩| 安远县| 太原市| 井冈山市|