ocp 11g題庫詳解：1Z0-051-059題
最新學訊：近期OCP認證正在報名中，因考試人員較多請盡快報名獲取最近考試時間，報名費用請聯系在線老師，甲骨文官方認證，報名從速！
我要咨詢ocp 11g題庫詳解：1Z0-051-059題，完整題庫請點擊這里聯系老師咨詢了解
59. View the Exhibit and examine the data in the PRODUCTS table.
You need to display product names from the PRODUCTS table that belong to the 'Software/Other '
category with minimum prices as either $2000 or $4000 and no unit of measure.
You issue the following query:
SQL>SELECT prod_name, prod_category, prod_min_price
FROM products
WHERE prod_category LIKE '%Other%' AND (prod_min_price = 2000 OR
prod_min_price = 4000) AND prod_unit_of_measure <> '';
Which statement is true regarding the above query?
A. It executes successfully but returns no result.
B. It executes successfully and returns the required result.
C. It generates an error because the condition specified for PROD_UNIT_OF_MEASURE is not valid.
D. It generates an error because the condition specified for the PROD_CATEGORY column is not valid.
Answer: A
試題解析：
因為prod_unit_of_measure <> ''該條件為假，’’相當于NULL，所以會導致該WHERE子句里所有AND連接的值為假，
雖然執行成功但不會返回結果，正確的條件應該是prod_unit_of_measure is not null。
