ocp 11g考試題庫詳解：1Z0-051-101題
最新學訊：近期OCP認證正在報名中，因考試人員較多請盡快報名獲取最近考試時間，報名費用請聯系在線老師，甲骨文官方認證，報名從速！
我要咨詢ocp 11g考試題庫詳解：1Z0-051-101題，完整題庫請點擊這里聯系老師咨詢了解
101. Examine the data in the PROMO_BEGIN_DATE column of the PROMOTIONS table:
PROMO_BEGIN _DATE
04-jan-00
10-jan-00
15-dec-99
18-oct-98
22-aug-99
You want to display the number of promotions started in 1999 and 2000.
Which query gives the correct output?
A. SELECT SUM(DECODE(SUBSTR(promo_begin_date,8),'00',1,0)) "2000",
SUM(DECODE(SUBSTR(promo_begin_date,8),'99',1,0)) "1999"
FROM promotions;
B. SELECT SUM(CASE TO_CHAR(promo_begin_date,'yyyy') WHEN '99' THEN 1
ELSE 0 END) "1999",SUM(CASE TO_CHAR(promo_begin_date,'yyyy') WHEN '00' THEN 1
ELSE 0 END) "2000"
FROM promotions;
C. SELECT COUNT(CASE TO_CHAR(promo_begin_date,'yyyy') WHEN '99' THEN 1
ELSE 0 END) "1999",COUNT(CASE TO_CHAR(promo_begin_date,'yyyy') WHEN '00' THEN 1
ELSE 0 END) "2000"
FROM promotions;
D. SELECT COUNT(DECODE(SUBSTR(TO_CHAR(promo_begin_date,'yyyy'), 8), '1999', 1, 0)) "1999",
COUNT(DECODE(SUBSTR(TO_CHAR(promo_begin_date,'yyyy'), 8),'2000', 1,
0)) "2000"
FROM promotions;
Answer: A
試題解析：
分析A答案
SUBSTR(promo_begin_date,8)，即是取日期的最后兩個值。
(DECODE(SUBSTR(promo_begin_date,8),'00',1,0)如果最后兩個值是00，則值為1，否則為0
(DECODE(SUBSTR(promo_begin_date,8),'99',1,0)如果最后兩個值是99，則值為1，否則為0
SUM(DECODE(SUBSTR(promo_begin_date,8),'00',1,0)) 加起來有多少個1，即有多少個2000年的
SUM(DECODE(SUBSTR(promo_begin_date,8),'99',1,0))加起來有多少個1，即有多少個1999年的
B，條件不對，應該 TO_CHAR(promo_begin_date,'yyyy') 改成 TO_CHAR(promo_begin_date,'yy')
C,與B同樣錯誤
D,截取不對，SUBSTR(TO_CHAR(promo_begin_date,'yyyy'), 8)改成SUBSTR(TO_CHAR(promo_begin_date,'yyyy'), 1)
