试题详情
- 单项选择题 The CUSTOMERS table has these columns: CUSTOMER_ID NUMBER(4) NOT NULL CUSTOMER_NAME VARCHAR2(100) NOT NULL STREET_ADDRESS VARCHAR2(150) CITY_ADDRESS VARCHAR2(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 DISTINCT UPPER(country_address)
E、COUNT(DISTINCT (UPPER(country_address)))
- E
关注下方微信公众号，在线模考后查看
热门试题
- Evaluate this SQL s
- 如果经常执行类似于下面的查询语句SELE
- 对于主键的说法错误的是（）。
- Which three
- Examine the structu
- Which four actions a
- Your boss̳
- You are
- You are using the co
- You have
- What does the FORCE
- Which three function
- Given： Which c
- Observe the&en
- Automatic data conve
- Given： Which c
- The SPFILE&ens
- Which of
- （）触发器允许触发操作的语句访问行的列值
- 当数据库运行在归档模式下时，如果发生日志