nerdexam
Oracle

1Z0-007 · Question #57

The CUSTOMERS table has these columns: The CUSTOMER_ID column is the primary key for the table. You need to determine how dispersed your customer base is. Which expression finds the number of…

The correct answer is E. COUNT(DISTINCT (UPPER(country_address))). See the full explanation below for the reasoning.

Question

The CUSTOMERS table has these columns:

The CUSTOMER_ID column is the primary key for the table. You need to determine how dispersed your customer base is. Which expression finds the number of different countries represented in the CUSTOMERS table?

Exhibit

1Z0-007 question #57 exhibit

Options

  • ACOUNT(UPPER(country_address))
  • BCOUNT(DIFF(UPPER(country_address)))
  • CCOUNT(UNIQUE(UPPER(country_address)))
  • DCOUNT DISTINCT UPPER(country_address)
  • ECOUNT(DISTINCT (UPPER(country_address)))

How the community answered

(20 responses)
  • A
    10% (2)
  • B
    5% (1)
  • C
    5% (1)
  • E
    80% (16)

Community Discussion

No community discussion yet for this question.

Full 1Z0-007 Practice