1z0-071 Exam — Question 199

Exam 1z0-071 All QuestionsBrowse all questions from this exam

Question 199

Examine the description of the CUSTOMERS table:

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_limit * .05 AS due_amount

FROM customers -

WHERE cust_income_level IS NOT NULL

AND cust_credit_limit 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 != NULL -

AND cust_credit_level != 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 IS NOT NULL

AND due_amount IS NOT NULL;

Correct Answer: A

To display customers whose income level has a value and to compute the due amount as 5% of their credit limit, you need to ensure that both the income level and credit limit are not null in your query. Also, the alias 'due_amount' cannot be used in the WHERE clause as it is defined in the SELECT clause. Option A correctly performs these checks and calculations using appropriate SQL syntax and ensures that only relevant records are selected.

Discussion

jfc1Option: A

A is the correct answer

wi11111Option: A

A should be correct

yaya32Option: A

A is correct

lucemqyOption: A

A you can't use alias in where clause

WingLOption: A

100% A CORRECT. THE STATEMENT WILL EXECUTE THE 'WHERE' CONDITION FIRST BEFORE SELECT STATEMENT.

zouveOption: E

E is the correct answer