📄 que_116.htm
字号:
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=gb2312">
<title>Ocp test </title>
</head>
<body bgcolor="white" text="black" link="blue" vlink="purple" alink="red">
<p align="left" color="black" style="font-size:16pt;">
<b>QUESTION 116 </b>
</p><hr color="#99CCFF">
<p>The CUSTOMERS table has these columns: </p><table border="1" bordercolor="gray">
<tr>
<td align="left" width="486" bgcolor="#99CCFF">
<p><b>CUSTOMERS table </b></p>
</td>
</tr>
<tr>
<td align="left" bgcolor="white">
<p><b>CUSTOMER_ID NUMBER (4) NOT NULL </b></p>
</td>
</tr>
<tr>
<td align="left" bgcolor="white">
<p><b>CUSTOMER_NAME VARCHAR2 (100) NOT NULL </b></p>
</td>
</tr>
<tr>
<td align="left" bgcolor="white">
<p><b>STREET_ADDRESS VARCHAR2 (150) </b></p>
</td>
</tr>
<tr>
<td align="left" bgcolor="white">
<p><b>CITY_ADDRESS VARHCAR2 (50) </b></p>
</td>
</tr>
<tr>
<td align="left" bgcolor="white">
<p><b>STATE_ADDRESS VARCHAR2 (50) </b></p>
</td>
</tr>
<tr>
<td align="left" bgcolor="white">
<p><b>PROVINCE_ADDRESS VARCHAR2 (50) </b></p>
</td>
</tr>
<tr>
<td align="left" bgcolor="white">
<p><b>COUNTRY_ADDRESS VARCHAR2 (50) </b></p>
</td>
</tr>
<tr>
<td align="left" bgcolor="white">
<p><b>POSTAL_CODE VARCHAR2 (12) </b></p>
</td>
</tr>
<tr>
<td align="left" bgcolor="white">
<p><b>CUSTOMER_PHONE VARCHAR2 (20) </b></p>
</td>
</tr>
</table>
<p>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? </p><table border="1" bordercolor="gray" width="665">
<form name="youAnsForm">
<span style="font-size:18pt;">
<tr>
<td align="center" width="89">
<p><b><input type="radio" name="AN" value="A"> A.</b></p>
</td>
<td align="left" width="566">
<p> COUNT(UPPER(country_address))
</p>
</td>
</tr>
<tr>
<td align="center" width="89">
<p><b><input type="radio" name="AN" value="B"> B.</b></p>
</td>
<td align="left" width="566">
<p> COUNT(DIFF(UPPER(country_address)))
</p>
</td>
</tr>
<tr>
<td align="center" width="89">
<p><b><input type="radio" name="AN" value="C"> C.</b></p>
</td>
<td align="left" width="566">
<p> COUNT(UNIQUE(UPPER(country_address)))
</p>
</td>
</tr>
<tr>
<td align="center" width="89">
<p><b><input type="radio" name="AN" value="D"> D.</b></p>
</td>
<td align="left" width="566">
<p> COUNT DISTINTC UPPER(country_address)
</p>
</td>
</tr>
<tr>
<td align="center" width="89">
<p><b><input type="radio" name="AN" value="E"> E.</b></p>
</td>
<td align="left" width="566">
<p> COUNT(DISTINTC (UPPER(country_address))</b></p>
</td>
</tr>
</span>
</form>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -