400-090-9964


博客 | 论坛

教学文章

【2020年8月】Oracle OCP 071考试新题(-3题)CUUG内部题库

时间:2020-09-16 来源:

【2020年8月】Oracle 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月份Oracle OCP 071考试新题(-3题)CUUG内部题库,钉钉群(35277291)Oracle金牌名师亲自题库解析

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

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

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

海淀校区:北京市海淀区紫竹院路88号紫竹花园4号楼D座703(CUUG)