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

Vince

1 days ago

Ah, I see. The key is to use IS NOT NULL instead of != NULL. That's a common gotcha in SQL questions. I'm feeling pretty confident about this one.

upvoted 0 times

...

Vicki

12 days ago

Haha, 'cust_credit_level'? I think they meant 'cust_credit_limit'. These exam questions can be a real mind-bender sometimes.

upvoted 0 times

Alishia

4 days ago

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;

upvoted 0 times

...

1 months ago

I think the correct query is option C.

upvoted 0 times

...