ocp 11g題庫詳解：1Z0-051-053題
最新學訊：近期OCP認證正在報名中，因考試人員較多請盡快報名獲取最近考試時間，報名費用請聯系在線老師，甲骨文官方認證，報名從速！
我要咨詢ocp 11g題庫詳解：1Z0-051-053題，完整題庫請點擊這里聯系老師咨詢了解
53. View the Exhibit and examine the data in the PROMOTIONS table.
PROMO_BEGIN_DATE is stored in the default date format, dd-mon-rr.
You need to produce a report that provides the name, cost, and start date of all promos in the POST
category that were launched before January 1, 2000.
Which SQL statement would you use?
A. SELECT promo_name, promo_cost, promo_begin_date
FROM promotions
WHERE promo_category = 'post' AND promo_begin_date < '01-01-00';
B. SELECT promo_name, promo_cost, promo_begin_date
FROM promotions
WHERE promo_cost LIKE 'post%' AND promo_begin_date < '01-01-2000';
C. SELECT promo_name, promo_cost, promo_begin_date
FROM promotions
WHERE promo_category LIKE 'P%' AND promo_begin_date < '1-JANUARY-00';
D. SELECT promo_name, promo_cost, promo_begin_date
FROM promotions
WHERE promo_category LIKE '%post%' AND promo_begin_date < '1-JAN-00';
Answer: D
試題解析：
在表達式中，Oracle Server 可以自動執行以下轉換：
從 VARCHAR2 或CHAR隱式轉換為NUMBER
從VARCHAR2 或CHAR隱式轉換為DATE，但必須符合日期的規定的格式。
Oracle Server 可以在表達式中自動執行數據類型轉換。例如，表達式hire_date > '01-JAN-90' 將導致字符串'01-JAN-90' 隱式轉換為一個日期。因此，表達式中的VARCHAR2 或CHAR 值可以隱式轉換為數字或日期數據類型。
