ocp考试资料群：569933648 验证码：ocp ocp 12c 19c考试题库解析与资料群：钉钉群号：35277291
全部博文（486）
- postgresql（55）
- ocp 12c（175）
- ocp（102）
- 未分配的博文（154）
- ·
- ·
- ·
- ·
- ·
- ·
- ·
- ·
- ·
- ·
分类： oracle
2020-09-11 15:37:47
【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金牌名师亲自题库解析