教学文章
Technology Exchange
热门课程
400电话

免费咨询热线
400-090-9964

教学文章

OCP 071中文考试题库(cuug内部资料)第57题

时间:2022-04-26 来源:

本套题库是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

版权所有@北京神脑资讯技术有限公司(CUUG,中国UNIX用户协会) Copyright ALL Rights Reserved 京ICP备11008061号-1

CUUG旗下网站:www.cuug.com.cn www.cuug.com oracle.cuug.com bbs.cuug.com www.cuug.net

电话:010-59426307 010-59426319 邮政编码:100089

地址:北京市海淀区北清路164号28-38号院