Oracle
1Z0-061 · Question #218
1Z0-061 Question #218: Real Exam Question with Answer & Explanation
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?
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)))
Community Discussion
No community discussion yet for this question.