Question 33

Question

Examine the description or the CUSTOMERS table:
https://kxbjsyuhceggsyvxdkof.supabase.co/storage/v1/object/public/file-images/1Z0-071/page_56_img_1.jpg
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?

Accepted Answer

SELECT 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;

Logan P. · Answer

C/D? I'd pick C since due_amount isn't a real column, so D is a trick.

PreciseDev6580 · Answer

C or D, but I think D is better fit since the question says to exclude rows where due_amount is null, not cust_credit_limit. Pretty sure D matches intent unless there's a column naming typo.

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?

Premium Access Includes

Oracle 1Z0-071 Real Exam Questions [October 2026 Update] Quiz

Premium Access Includes