本文主要向大家介绍了Oracle数据库之【OCP题库】最新CUUG OCP 12c 071考试题库（65题），通过具体的内容向大家展现，希望对大家学习Oracle数据库有所帮助。

65、(22-16) choose the best answer:

The CUSTOMERS table has the following structure:

You need to write a query that does the following tasks:

1. 
   

   Display the first name and tax amount of the customers. Tax is 5% of their credit limit.

   
   




2. 
   

   Only those customers whose income level has a value should be considered.

   
   




3. Customers whose tax amount is null should not be considered.

Which statement accomplishes all the required tasks?

A) SELECT cust_first_name, cust_credit_limit * .05 AS TAX_AMOUNT

FROM customers

WHERE (cust_income_level,tax_amount) IS NOT NULL;

B) SELECT cust_first_name, cust_credit_limit * .05 AS TAX_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 TAX_AMOUNT

FROM customers

WHERE cust_income_level <> NULL AND

tax_amount <> NULL;

D) SELECT cust_first_name, cust_credit_limit * .05 AS TAX_AMOUNT

FROM customers

WHERE cust_income_level IS NOT NULL AND

tax_amount IS NOT NULL;

Answer：B

(解析：条件语句中不能用别名当做条件，该题的题意是税额不能为 0，所以只要 cust_credit_limit 不为 0，则保证税额不会为 0

本文由职坐标整理并发布，希望对同学们学习Oracle有所帮助，更多内容请关注职坐标数据库Oracle数据库频道！