OCP 071中文考試題庫(cuug內部資料)第57題
最新學訊：近期OCP認證正在報名中，因考試人員較多請盡快報名獲取最近考試時間，報名費用請聯系在線老師，甲骨文官方認證，報名從速！
我要咨詢本套題庫是OCP考試中的071(中文版)試題，由CUUG整理，如有報考OCP認證意向，可以聯系cuug咨詢老師。
57、請選擇最佳答案。
查看CUSTOMERS表的說明:
Name Null? Type
-------- -------- --------
CUST_ID NOT NULL NUMBER
CUST_FIRST_NAME NOT NULL VARCHAR2 (20)
CUST_LAST_NAME NOT NULL VARCHAR2 (30)
CUST_INCOME_LEVEL VARCHAR2 (30)
CUST_CREDIT_LIMIT NUMBER
對于收入水平有值的客戶, 您希望顯示客戶名字和到期金額(值為信用額度的5%)。不顯示到期金額為null 的客戶。
應使用哪個查詢?
A) SELECT cust_first_name, cust_credit_limit * .05 AS due_amount
FROM customers
WHERE cust_income_level Is NOT NULL
AND due_amount Is NOT NULL; .
B) SELECT cust_first_name, cust_credit_limit * .05 AS due_amount
FROM customers
WHERE cust_income_level != NULL
AND due_amount != NULL;
C) SELECT cust_first_name, cust_credit_limit * .05 AS due_amount
FROM customers
WHERE cust_income_level IS NOT NULL
AND cust_credit_limit IS NOT NULL;
D) SELECT cust_first_name, cust_credit_limit * .05 AS due_amount
FROM customers
WHERE cust_income_level <> NULL
AND due_amount <> NULL;
E) SELECT cust_first_name, cust_credit_limit * .05 AS due_amount
FROM customers
WHERE cust_income_level != NULL
AND cust_credit_level != NULL;
整理：cuug
