Oracle Exam 1Z0-071 Topic 3 Question 96 Discussion

Actual exam question for Oracle's 1Z0-071 exam

Question #: 96
Topic #: 3

Examine the description or 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?

ASELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT FROM customers
WHERE cust_income_level != NULL AND cust_credit_level != NULL;

BSELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMONT FROM customers
WHERE cust_income_level <> NULL AND due_amount <> NULL;

CSELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMONT FROM customers
WHERE cust_income_level IS NOT NULL AND cust_credit_limit IS NOT NULL;

DSELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMONT FROM customers
WHERE cust_income_level IS NOT NULL AND due_amount IS NOT NULL;

ESELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMONT FROM customers
WHERE cust_income_level != NULL AND due_amount != NULL;

Show Suggested Answer

Suggested Answer: D, E

by Pilar at Jun 28, 2024, 12:14 PM

Limited Time Offer

25%

Off

Get Premium 1Z0-071 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Antonio

11 days ago

Okay, let's see. We need to display the first name and the due amount as 5% of the credit limit, but only for customers with a non-null income level. I think option C is the way to go.

upvoted 0 times