Chinaunix首页 | 论坛 | 博客
  • 博客访问: 494492
  • 博文数量: 449
  • 博客积分: 0
  • 博客等级: 民兵
  • 技术积分: 4546
  • 用 户 组: 普通用户
  • 注册时间: 2018-07-05 13:59
个人简介

ocp考试资料群:569933648 验证码:ocp OCP 12c 19c考试题库解析与资料群:钉钉群号:35277291

文章分类

全部博文(449)

文章存档

2023年(1)

2021年(151)

2020年(37)

2019年(222)

2018年(38)

我的朋友

分类: 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金牌名师亲自题库解析

阅读(698) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~