nerdexam
Oracle

1Z0-061 · Question #45

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…

The correct answer is B. Option B. See the full explanation below for the reasoning.

Question

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?

Exhibits

1Z0-061 question #45 exhibit 1
1Z0-061 question #45 exhibit 2

Options

  • AOption A
  • BOption B
  • COption C
  • DOption D

How the community answered

(23 responses)
  • A
    9% (2)
  • B
    74% (17)
  • C
    4% (1)
  • D
    13% (3)

Community Discussion

No community discussion yet for this question.

Full 1Z0-061 Practice