【2020年8月】OCP 071考試新題(-3題)CUUG內部題庫
最新學訊：近期OCP認證正在報名中，因考試人員較多請盡快報名獲取最近考試時間，報名費用請聯系在線老師，甲骨文官方認證，報名從速！
我要咨詢【2020年8月】OCP 071考試新題(-3題)CUUG內部題庫
Choose the best answer.
Examine the description of the CUSTOMERS table:
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
For customers whose income level has a value, you want to display the first name and due amount as 5% of their credit limit. Customers whose due amount is null should not be displayed.
Which query should be used?
A) SELECT cust_first_name, cust_credit_1imit * .05 AS due_amount
FROM customers
WHERE cust_income_level != NULL
AND cust_credit_level != NULL;
B) 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;
C) 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; .
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 due_amount <> NULL;
2020年8月份OCP 071考試新題(-3題)CUUG內部題庫，釘釘群(35277291)Oracle金牌名師親自題庫解析
