试题详情
- 单项选择题 The CUSTOMERS table has these columns: CUSTOMER_ID NUMBER (4) NOT NULL CUSTOMER_NAME VARCHAR2 (100) NOT NULL STREET_ADDRESS VARCHAR2 (150) CITY_ADDRESS VARHCAR2 (50) STATE_ADDRESS VARCHAR2 (50) PROVINCE_ADDRESS VARCHAR2 (50) COUNTRY_ADDRESS VARCHAR2 (50) POSTAL_CODE VARCHAR2 (12) CUSTOMER_PHONE VARCHAR2 (20) 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?()
A、COUNT(UPPER(country_address))
B、COUNT(DIFF(UPPER(country_address)))
C、COUNT(UNIQUE(UPPER(country_address)))
D、COUNT DISTINTC UPPER(country_address)
E、COUNT(DISTINTC (UPPER(country_address)))
- E
关注下方微信公众号,在线模考后查看
热门试题
- Given: What is
- ViewtheExhibitexhibi
- Evaluate this SQL s
- Evaluate the&en
- Which two̳
- You are
- Given: What is
- Given: What is
- You are maintaining
- When you
- Which of
- You are u
- Given: Which c
- 当Select Into语句的返回多于一
- Evaluate the SQL st
- ExaminethefollowingR
- Which background pro
- In your d
- 下列哪一个后台进程和对应的数据库组件能够
- Which three statemen